RE: Another Question on Authority and Security

[Jamadagni, Rajendra]

Title: RE: Question related to security

Kevin,

 

in all cases ... when you execute my_procedure you will see privileges as user_a ... because unless you use invoker's rights, the procedure will inherit privileges of the schema owner. User_b/c can compile just because they have privilege, nothing less, nothing more.

 

Raj

-------------------------------------------------------------
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !!

-----Original Message-----
From: Kevin Lange [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 05, 2003 4:31 PM
To: Multiple recipients of list ORACLE-L
Subject: Another Question on Authority and Security

Given:

  User_A Owns procedure 'MY_PROCEDURE'.

  User_B originally compiles procedure ''USER_A.MY_PROCEDURE", thereby allowing 'MY_PROCEDURE" to be able to do whatever User_B can.

  User_C recompiles "USER_A.MY_PROCEDURE"  by issuing the "ALTER PROCEDURE USER_A.MY_PROCEDURE COMPILE;" command.

 

Question:

  Is procedure "USER_A.MY_PROCEDURE" now able to do whatever User C can do instead of User B ??  Or does it retain the authority from User_B instead.

 

Thanks

 

Kevin

********************************************************************This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*********************************************************************2