Home » RDBMS Server » Security » To find user privileges on a table (oracle 11g)
To find user privileges on a table [message #660620] Wed, 22 February 2017 22:21 Go to next message
Sgupta
Messages: 1
Registered: February 2017
Junior Member
can anybody please tell me how to find out a user privilege on a specific table in database.
Re: To find user privileges on a table [message #660621 is a reply to message #660620] Thu, 23 February 2017 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 65196
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have a look at %_TAB_PRIVS views.

Re: To find user privileges on a table [message #660632 is a reply to message #660621] Thu, 23 February 2017 03:40 Go to previous messageGo to next message
gazzag
Messages: 905
Registered: November 2010
Location: Bristol, UK
Senior Member
ALL_TAB_PRIVS.
Re: To find user privileges on a table [message #660651 is a reply to message #660632] Thu, 23 February 2017 11:23 Go to previous message
Solomon Yakobson
Messages: 2675
Registered: January 2010
Location: Connecticut, USA
Senior Member
And DBA_ROLE_PRIVS (recursively) to check if user has privilege on a specific table in database via role.

SY.
Previous Topic: Transparent Database Encryption
Next Topic: Secure Connection
Goto Forum:
  


Current Time: Mon Nov 20 11:26:20 CST 2017

Total time taken to generate the page: 0.32386 seconds