READ ONLY USER

READ ONLY USER

SQL> create tablespace testuser datafile '/data1/proddata/testuser.dbf'size 100m

SQL> select file_name,bytes/1024/1024 from dba_data_files where tablespace_name='TESTUSER'

SQL> create user testuser identified by testuser

SQL> alter user testuser default tablespace testuser

SQL> grant connect to testuser

SQL> grant select on dba_source to testuser

SQL> grant select on dba_objects to testuser

SQL> grant select any table to testuser

(INCASE IF GIVING COMPLETE GRANT ON ANY PACKAGE OR PROCEDURE)

SQL> grant execute, debug on <PACKAGE / PROCEDURE NAME > to testuser

------------------------------------------