| Author |
General SQL question
|
|
| oracle_noob 2002-10-11, 11:08 am |
| If you grant a privilege to Table T "with grant option" to user1, who in turns grant privilege to user2, will user2 lose the privilege automatically if you revoke the privilege from user1? | |
| laloca 2002-10-11, 4:22 pm |
| No - revoke has no cascading effects, user2 will keep all granted privileges ..  | |
| oracle_noob 2002-10-12, 11:33 am |
| Even with object privileges? | |
| laloca 2002-10-12, 12:21 pm |
| hmm ... you're right:
revoking object privileges will cascade when given using WITH GRANT OPTION:
user1 is granted an object privilege with the GRANT OPTION.
user1 grants this object privilege to user2
object privilege is revoked from user1 - revoke is cascaded to user2 as well.
the non-cascading effect is only valid for system privileges - sorry  |
|
|
|