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: 68625
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: 1118
Registered: November 2010
Location: Bedwas, 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: 3269
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: connecting sqlplus without password
Next Topic: How to software use database security?
Goto Forum:
  


Current Time: Fri Mar 29 07:55:59 CDT 2024