Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Issue/Symptom/Question

Create read-only database user to run queries

Environment

Oracle Database System Privileges

Golden

Resolution/Fix/Answer

This should be done by an Oracle Database Administrator (DBA). If you do not have one, please open up a Service Desk ticket and reference this article.

To setup a read-only database user:

  1. Create the user

    create user pentaro identified by <somepassword> default tablespace users temporary tablespace temp;
    grant create session to pentaro;
    grant create synonym to pentaro;
  2. Grant select on table or view in the PENTA schema to the user you created.

    grant select on <sometable> to pentaro;
  3. The read-only user then creates synonyms for each table or view they want to query.

    create synonym <sometable> for penta.<sometable>;
  • No labels