0

I want to be able to see what permissions have been granted on a specific object in my Oracle geodatabase. What would my syntax look like in SQL Plus?

Thank you.

1

You can check object privileges on tables through the view dba_tab_privs.

Here's a query:

SELECT grantee, privilege FROM dba_tab_privs WHERE table_name='XXXXX';

You can also learn more about privileges and stuff from this really cool website:

http://www.dba-oracle.com/forensics/t_forensics_object_privileges.htm

  • Thanks a lot. Burleson is the man. I knew it was something along those lines but couldn't get it. Thanks Eric! – geogeek Oct 3 '14 at 4:31
  • No problem, man! Have a good night. – Eric Larson Oct 3 '14 at 4:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.