OraFAQ Forum: Security » To find user privileges on a table

Home » RDBMS Server » Security » To find user privileges on a table (oracle 11g)

Wed, 22 February 2017 22:21

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.

Thu, 23 February 2017 00:59

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Have a look at %_TAB_PRIVS views.

Thu, 23 February 2017 03:40

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Thu, 23 February 2017 11:23

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.

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

Goto Forum:

]

Current Time: Fri May 16 08:38:14 CDT 2025