Home » RDBMS Server » Server Administration » finding user privileges on a table
finding user privileges on a table [message #134912] Mon, 29 August 2005 00:03 Go to next message
vgs2005
Messages: 123
Registered: April 2005
Senior Member
how do I find what privileges (say SELECT, UPDATE, DELETE or INSERT) are granted to a user on a table? .. thanks in advance..

Report message to a moderator

Re: finding user privileges on a table [message #134916 is a reply to message #134912] Mon, 29 August 2005 00:13 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Use

USER_TAB_PRIVS, ALL_TAB_PRIVS , DBA_TAB_PRIVS as per ur requirement.


regards,
tarun

Report message to a moderator

Previous Topic: OEM
Next Topic: how to pass message to client from server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 11:22:06 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.