OraFAQ Forum: Server Administration » To know all the user privileges

Home » RDBMS Server » Server Administration » To know all the user privileges

Tue, 04 July 2006 01:45

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

Hi All,
How to know all the privileges given to a user.

It includes everything like system,roles etc.

Have a great day.

Thanks And Regards
Dinesh

Tue, 04 July 2006 02:27

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

You could check USER_ROLE_PRIVS, USER_SYS_PRIVS and USER_TAB_PRIVS, along with USER_TAB_PRIVS_RECD.

Tue, 04 July 2006 03:29

d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta

Senior Member

Thanks A Lot.

With Regards
Dinesh

Previous Topic:	Can a user access a table during the online backup?
Next Topic:	Create index script

Goto Forum:

]

Current Time: Fri Sep 20 10:42:17 CDT 2024