I need to create a user that has read access to all the schemas. Do they just need Select priviliges or is there more that needs to be done?
How to create an Oracle 11g user with read access to all tables/schemas
oracle-11g
Related Question
- Union of data from all tables with name containing a substring
- Global command to destroy all disconnected data files in Oracle 11g
- Changing own user permissions with Oracle SQL not being the DBA
- Oracle – execute DML query as different user
- Oracle Enterprise Manager 11g: How to see statistics of Interfaces usage
- How to create a new database with new sid on Oracle’s pre-built 11g virtual machine
- How to create a database user for oracle 11g on windows 8
- Lock out of Oracle based on Windows username
Best Answer
You can grant
SELECT ANY TABLE
, however, that is seen by some as "excessive" privileges, and should be questioned.On the plus side, Oracle 11 keeps key system views hidden even from that grant .. so it's not nearly as bad as it once was ;)
It would be best to build
ROLEs
and grant theSELECTs
to the required tables to theROLEs
... then grant theROLE
to your users as needed.If you haven't yet, you should probably read over this guy:
https://docs.oracle.com/cd/B28359_01/network.111/b28531.pdf