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
The best way of checking the current user privileges on a particular table from another schema
oraclepermissions
Related Question
- Sql-server – How to connect multiple users/schemas in Oracle 11g
- Special setup to create views in Oracle in default schema
- Mysql – Simplest way to check if current user has permission to a MySQL table (from PHP / thesqli) for some desired operation
- Mysql – What are the minimal permissions required for the “Users and Privileges” tab in MySQL Workbench to function in MySQL 5.6
- What permissions are required for complex cross-schema materialized view in Oracle
- Is it possible to grant a user the equivalence of ownership over a another users schema
- Are there any downsides to referencing tables from another schema using synonyms
Best Answer
ALL_TAB_PRIVS
is a superset ofALL_TAB_PRIVS_RECD
. You probably wantALL_TAB_PRIVS
as it includes tables that the current user owns.