| anil |
Posted: Jan 28, 2008 01:04:08 PM |
Total Post: 29
Joined: Dec, 2007
|
there is three user's and one dba
the dba gave sys privilege to uers one with grant option
then the user one gave the same privilege to other two and three users
if the dba revoke sys privilege to user one so what about the user two and three both have the privilege or revoke auto because the parent user privilege are revoked by dba
what will be happen? |
|
|
Mohammed Taj |
| Posted: Jan 28, 2008 11:20:28 PM | |
|
Total Post: 746
Joined: Jul, 2007
|
Anil,
did you try with yourself ?
|
|
|
|
|
Murtuja |
| Posted: Jan 29, 2008 01:17:53 AM | |
|
Total Post: 843
Joined: Jan, 2006
|
Hi Anil,
Read this
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96521/privs.htm#15521
HTH
|
|
|
|
|
shahul |
| Posted: Jan 29, 2008 11:29:00 AM | |
|
Total Post: 17
Joined: Sep, 2007
|
Hi,
The users two and three remains with same privilege.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |