rman backup and logical backup using different user

Article on: Rman backup or logical backup using expdp can be taken with different user. If database has not any catalog database, this approach will be help full for rman backups.  Logical backup using the same user can be taken. So that sys privillege will be more secure.

Applies to: Above Oracle version 10.2.x.x.x
 
rman backup using bkp_user:

-- Create the user

create user BKP_USER
  identified by BKP_USER
  default tablespace USERS
  temporary tablespace TEMP
  profile DEFAULT;
grant CONNECT to BKP_USER;
grant EXP_FULL_DATABASE to BKP_USER;
grant IMP_FULL_DATABASE to BKP_USER;
grant RECOVERY_CATALOG_OWNER to BKP_USER;
grant SELECT_CATALOG_ROLE to BKP_USER;
grant CREATE SESSION to BKP_USER;



$ rman

RMAN> connect target bkp_user/bkp_user

connected to target database: AHDEL (DBID=62083845)

rman >

RMAN> backup database;

Note: Script can be written and job can be scheduled to take backup.

Thanks