Saturday, January 2, 2016

How To Find Out What Privileges a User Currently Has?

Privileges granted to users are listed in two system views: DBA_SYS_PRIVS and USER_SYS_PRIVS.
We can find out what privileges a user currently has by running below query - as normal user
We can find out what privileges a user currently has by running below query - as SYS user

No comments: