Login
sententia
Home
Blog
How to find the privileges and roles granted to a user in Oracle
Home
/
Blog
/
How to pass host, port, SID/Service name to connect to a oracle database
/ How to find the privileges and roles granted to a user in Oracle
DBA don't grant us rights anymore to dictionary for us to easily see the user info (SELECT ANY DICTIONARY privilege)
from:
https://stackoverflow.com/questions/15066408/how-to-find-the-privileges-and-roles-granted-to-a-user-in-oracle
If you log in as the user you can run these
SELECT
*
FROM
USER_ROLE_PRIVS
select
*
from
USER_SYS_PRIVS
select
*
from
USER_TAB_PRIVS
*
Email / Username:
*
Password:
*
Remember me.
Forgot your password?