WebJul 27, 2016 · 2 Answers Sorted by: 1 I was able to find an answer somewhere else. So I need to query role_tab_privs. Here is the query in case somebody else will need it: select role, table_name, privilege from role_tab_privs where table_name in ('TABLE_NAME') order by role; Share Improve this answer Follow edited Aug 1, 2016 at 9:38 dezso 30.1k … WebApr 2, 2024 · This may involve checking the user's roles and privileges using the SQL Command Line or Oracle Enterprise Manager. Check the syntax of the SQL commands to ensure that they are properly formatted and do not contain any typos or errors.
Oracle SQL Query to Check User Permissions - OrclQA.Com
WebDec 27, 2024 · Below is the SQL command to find ROLE PRIVILEGES, click here for sample output. SELECT 'ROLE PRIVS' TYPE, GRANTEE,GRANTED_ROLE,ADMIN_OPTION,DEFAULT_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE='TESTUSER12' ORDER BY GRANTED_ROLE; WebJun 3, 2009 · select * from ( select object_name objname, object_type, 'my object' details, 1 resolveOrder from user_objects where object_type not like 'SYNONYM' union all select synonym_name obj , 'my synonym', table_owner '.' table_name, 2 resolveOrder from user_synonyms union all select synonym_name obj , 'public synonym', … proposal shred template
oracle - list users with access to certain tables
WebOct 3, 2013 · In order to find out the users and the profile assigned you can use the commands below. DESC DBA_USERS; This will show you all the fields name for which you want to query. SELECT USERNAME, PROFILE, ACCOUNT_STATUS FROM DBA_USERS; And this command will show you the user name, profile and account … WebDec 27, 2024 · Below is the SQL command to find ROLE PRIVILEGES, click here for sample output. SELECT 'ROLE PRIVS' TYPE, … WebSep 17, 2024 · 2 Answers. Sorted by: 2. I would recommend to use SYSIBMADM.PRIVILEGES. AUTHIDTYPE would be R for role. Or query SYSCAT.ROLEAUTH to retrieve only the role information, e.g., who granted which role to which user. Share. Follow. request letter for releasing gratuity