Question: I need to create a read-only user
within my schema. How can you grant read-only access for a single
user without granting read to every table?
Answer: You can make any user read-only
with the grant select any table privilege:
SQL>create user scott_read_only_user identified by readonly;
SQL>grant create session
SQL>grant select any table to
This will only grant read-only to scott tables, you would need to
connect to another schema owner to grant them read-only access.
Optionally, you can add read-only dictionary acces:
SQL>grant select any dictionary to scott_read_only_user;
For more, see the book
Easy Oracle Jumpstart.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.