Home » RDBMS Server » Server Administration » user to user grant
user to user grant [message #240272] Thu, 24 May 2007 09:00 Go to next message
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 #240277 is a reply to message #240272] Thu, 24 May 2007 09:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this homework?

Regards
Michel
Re: user to user grant [message #240297 is a reply to message #240277] Thu, 24 May 2007 10:10 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
look at here

http://www.psoug.org/reference/object_privs.html

and then here

http://www.psoug.org/reference/system_privs.html
Re: user to user grant [message #240479 is a reply to message #240277] Fri, 25 May 2007 00:44 Go to previous messageGo to next message
akba
Messages: 2
Registered: March 2007
Location: kolkata
Junior Member
hi michel..

this is a homenetwork.
connected by lan.
Re: user to user grant [message #240488 is a reply to message #240479] Fri, 25 May 2007 01:03 Go to previous message
Michel Cadot
Messages: 64103
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
Previous Topic: redologfile
Next Topic: diff between until time and until cancel
Goto Forum:
  


Current Time: Sun Dec 04 04:18:10 CST 2016

Total time taken to generate the page: 0.10204 seconds