Re: system privilege

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 8 Feb 2000 17:18:07 +0100
Message-ID: <87pfk5$2f5m$1@news4.isdnet.net>

If your special functions are relative to the access to some datas and if you are using in Oracle8i, you can use Virtual Private Database aka Fine Grained Access Control or Row Level Security. You have a white paper at http://www.oracle.com/oramag/oracle/99-Jul/49sec.html or at Thomas Kyte site: http://govt.oracle.com/~tkyte/article2/index.html

--
Michel

Leif Kuschel <Leif.Kuschel_at_t-online.de> a écrit dans le message : 87pee4$c3vm$1_at_fu-berlin.de...
> Hello Michel,
>
> thanks for your very fast answer.
>
> Unfortunately it's not realy my problem. I use oracle from an external
> program and some functions should only be used by special users.
>
> So this privileges are unknown in oracle. With a new role I can only use
> oracle privileges. But you give me an idea. I can use the name
> to specify the privilege. If an user has this role, so he has the privilege.
> I think it's not a good way, but it is one. If you have a better idea, let
> me know it.
>
> Have a nice day too,
> Leif
>
>
Received on Tue Feb 08 2000 - 10:18:07 CST