| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question related to security
If I were the famous d'Artagnan, I would challenge you to a duel for
insulting my honour, but since I'm a 21st century man I will instead thank
you for teaching me something I didn't know.
-----Original Message-----
Your first statement is no longer true for 9.2 and later (it still remains true for earlier releases). In 9.2 the new system privilege, GRANT ANY OBJECT PRIVILEGE, allows users to grant and revoke privileges on objects on behalf of the object's owner to simplify the installation process.
-----Original Message-----
Kilchoer
Only UserA can grant access on a table belonging to UserA (unless another
user was granted access with admin option.)
However, UserB can create a procedure in the schema of UserA if UserB has
CREATE ANY PROCEDURE system privilege.
The procedure created will run with the privileges of UserA, and will be
able to grant access on tables belonging to UserA.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com
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). Received on Wed Mar 05 2003 - 16:49:12 CST
 |
 |