| user to user grant [message #240272] |
Thu, 24 May 2007 09:00  |
akba
Messages: 2
Registered: March 2007
Location: kolkata
|
Junior Member |
|
|
hi...
there are two users attn and pay.
And it is possible to delete,update,select pay objects from attn.
how can I revoke delete,update privilege from attn?i mean the sql statement.
And how can i see the information abt what kind of privileges are there on pay(user).i mean is there any data dictionary for user to user grant?
OR how can i check that whether pay user has DBA grant..
any help will be appreciable..
|
|
|
|
|
|
|
|
|
|
| Re: user to user grant [message #240488 is a reply to message #240479] |
Fri, 25 May 2007 01:03  |
 |
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
Then you have to first post what you already tried.
We don't do your homework for you but we'll be glad to help you find the solution.
Here's some clue.
Yes
Revoke statement
There are dictionary views, search for %PRIV% in the view list.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
