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.

Report message to a moderator

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: 68758
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Have a look at %_TAB_PRIVS views.

Report message to a moderator

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: 1119
Registered: November 2010
Location: Bedwas, UK
Senior Member
ALL_TAB_PRIVS.

Report message to a moderator

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: 3305
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.

Report message to a moderator

Previous Topic: connecting sqlplus without password
Next Topic: How to software use database security?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 06 13:05:36 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.