oracle list user grants

Solutions on MaxInterview for oracle list user grants by the best coders in the world

showing results for - "oracle list user grants"
Kim
02 Jan 2017
1-- List privileges, including roles, for my_user
2SELECT GRANTEE, PRIVILEGE AS PRIVILEGE_ROLE,
3       NULL AS OWNER, NULL AS TABLE_NAME, NULL AS COLUMN_NAME,
4       ADMIN_OPTION AS PRIVILEGE, 
5       NULL AS GRANTABLE
6FROM DBA_SYS_PRIVS WHERE GRANTEE = 'my_user'
7UNION ALL
8SELECT r.GRANTEE, r.GRANTED_ROLE AS PRIVILEGE_ROLE, p.OWNER, p.TABLE_NAME, 
9	p.COLUMN_NAME, PRIVILEGE, p.GRANTABLE
10FROM DBA_ROLE_PRIVS r LEFT JOIN ROLE_TAB_PRIVS p ON p.ROLE = r.GRANTED_ROLE
11WHERE r.GRANTEE = 'my_user';
queries leading to this page
how to give privileges to users in oraclehow to grant a user to access another user table in oracle sqloracle view grants for userfind grants for a user in oracleoracle grant dba to userprivileges oracle usershow i can give the privileges to user in oraclesee all permissions for each user in oracleoracle current usercheck object level privileges for schema in oracle main privileges oracle userslet user grant privileges oracleview oracle privileges for userhow to give system privileges to user in oraclegrant all privileges to user in oracleget all privilegs of user in oracleoracle give privileges useroracle grantshow to check privileges of oracle userhow to get user privileges in oracleuser privileges oraclegrant create view privilege to user in oraclecheck the privileges that a user has grantedoracle user privilegesoracle dba privilegesgive to user oracle any privilegescreate user oracle with all privilegesoracle give all privileges to usergrant all privileges oracle userhow to check privileges granted to user in oraclegrant full privileges to user in oraclegive all privileges to user in oraclecheck privileges for schema in oracleoracle display privileges for userhow to get privileges of user in oraclegrant user in oracleoracle db user system privilegesgrant sysdba privileges to user in oraclehow to give privileges to user in oracleadd all privileges to user oraclegrant oracle user sysdba privilegesgrant user all privileges oraclecheck privileges user oraclecheck oracle user privilegesoracle list privilegesoracle show privileges of useroracle create user with all privilegescreate user and grant privileges in oracleoracle user all user privileges in oracleall privileges oraclegrant view privileges to user in oraclehow to check user privileges in oracle sql developerhow to create user with all privileges in oracleoracle set privileges to userhow to grant all privileges to user in oraclegrant user to view oraclehow to give privileges to new user in oraclehow to grant privileges to user in oracleoracle select all privileges for useroracle user grantoracle how to check user privilegesselect user oraclehow to check privileges of a user in oraclegrant privileges for user s oraclegrant user all oraclegiving all privileges user oraclehow to check privileges of a user in oracle databasecreate oracle user with all privilegescheck user privileges in oraclehow to check schema privileges in oracleoracle check my privilegessystem user privileges in oraclegrant privileges to user in oraclegrant sys privileges to user in oracleelementary privileges oracle usersoracle user grantsoracle select all permissions for usergrant all privileges oracle to usershow privileges user oraclegrant admin privileges to user in oraclegranting all privileges to user in oraclehow to check user privileges in oraclegrant sys to user in oracleoracle create user and grant all privilegesuser privileges in oraclecreate user in oracle with all privilegesoracle show privilege usercreate user grant all privileges oracleoracle privileges usersgrant privileges to all users in oracleoracle sql grant privileges to user adminuser privil c3 a8ges oracleoracle check user privilegesgive user all privileges oraclegrant user oracle all privilegesoracle allow user to grant privilegesoracle grant all privileges to useroracle list user grants