Antw: Privileges and PL/SQL code

Hi Stefan,

since 8 (i?):
have a look at AUTHID CURRENT USER in the docs. This enables using of database roles.

Greetings,
Guido

>>> Stefan.Jahnke_at_bov.de 14.07.2003 14.30 Uhr >>>
Hi list

I was wondering if there is any way to get the following to work:

User A owns all tables, users B,C own PL/SQL code to access A's tables. To work with A's tables from user B and C, I would like to create a role to contain all the object privileges and grant these to B and C.

Didn't use to work, since PL/SQL is not particularly interested in grants received through roles.
But I don't really want to grant all privileges directly to B and C (and many more users).

Is there a way in 9i that works better ? Any improvements I missed out on ?

Thanks in advance,
Stefan  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Stefan Jahnke
  INET: Stefan.Jahnke_at_bov.de 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).