Skip to content
October 27, 2011 / doganay

RMAN USER AND CATALOG USER NECESSARY GRANTS

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

 

Hi,

 

You must grant these to rmanuser (db user) and catalog user (rman catalog) in order to accomplish a successful backup:

 

catalog
-------------------
GRANT EXP_FULL_DATABASE TO mycataloguser;
GRANT RECOVERY_CATALOG_OWNER TO mycataloguser;
GRANT CONNECT TO mycataloguser;
ALTER USER mycatalog DEFAULT ROLE ALL;
ALTER USER mycatalog QUOTA UNLIMITED ON ;
GRANT SELECT ON SYS.ROLE_ROLE_PRIVS TO mycataloguser;
GRANT SELECT ON SYS.USER_ROLE_PRIVS TO mycataloguser;
GRANT SELECT ON SYS.USER_TAB_PRIVS TO mycataloguser;


rmanuser
------------------
alter user rmanuser quota unlimited on users;
grant create session, alter session, sysdba to rmanuser;

 

try and pray 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: