I have created a user and want to grant the user read only privileges on all database schemas. Can I do that using a single grant statement for all 20 schemas.
Read only privileges
oraclepermissions
Related Question
- Create Read-Only User in Oracle – Step-by-Step Guide
- Oracle 12c – Privileges to Select on a View
- MySQL Permissions – Grant Read-Only Access for One DB and Create/Drop Access for Others
- PostgreSQL – How to Grant Privileges as Superuser
- PostgreSQL read only user
- MariaDB: How to grant read-only privileges for Stored Procedures
Best Answer
This may not exactly what you want, but it should be close enough.
grant read any table to username;This provides read privileges on all user tables and views (but no privileges on dictionary tables or
DBA_catalog views).If you want to this only for specific schemas, you need to grant the specific object privileges.