Installation Guide

Back Next

Create a Read-only User in Oracle

Create a read-only user, for example pcrs_readonly.

Grant the following privileges to the user:

ALTER TABLE

CREATE INDEX

CREATE SESSION

CREATE SYNONYM

CREATE TABLE

CREATE VIEW

INSERT INTO TABLE

If you are going to monitor the Informatica environment for operations, perform the following task:

grant select on sys.dba_free_space to <read only user name>;
grand select on sys.dba.data_files to <read only user name>

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.