PROTECTED]
Sent by: [EMAIL PROTECTED] cc:
Subject: Antw:
Privileges and P
Hi Stefan,
since 8 (i?):
have a look at AUTHID CURRENT USER in the docs.
This enables using of database roles.
Greetings,
Guido
>>> [EMAIL PROTECTED] 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/SQ
Title: RE: Privileges and PL/SQL code
That's what I was afraid of 8-{ ... oh
well.
Since
we have several developer's working on local copies of the code in schemas B, C,
etc.,
I
guess I have to grant privileges to all schemas.
Thanks
for the quick response.
Stefan
Ste
Title: RE: Privileges and PL/SQL code
If you don't want to do that, create your pl/sql code under schema A and grant execute on those to B and C.
Sorry ... that's the only way to go ...
Raj
Ra
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