In my software, at runtime, I need to check if the connected user has the privileges on some tables, across 2 different schemas. From what I found doing research, I came across these 2 views ALL_TAB_PRIVS_RECD ALL_TAB_PRIVS Should I use one of these views, or is there another better way to do it? Thanks
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
I finally came with this query that I use only if the connected user is different than the schema I want to check privileges on:
This checks the SELECT privilege on the table GN_VERSION on the USER_A schema