Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008
    Posts
    6

    Unanswered: Create a user who can run only 'rman script'

    Dear Friends ,

    I have created a 'rmanback; user who only can run the RMAN script only . I have created user like follwoing way :

    1)
    SQL> CREATE USER rmanback IDENTIFIED BY rmanback;

    User created.

    SQL> GRANT RECOVERY_CATALOG_OWNER TO rmanback;

    Grant succeeded.

    SQL> GRANT CONNECT, RESOURCE TO rmanback;

    Grant succeeded.

    2)
    And My rman script is :

    rman target rmanback/rmanback@orcl <<!
    run
    {
    allocate channel t1 type disk;
    backup format 'df_%t_%s_%p'
    (database);}

    3) And I make a situation where sys user cannot enter the database using its password . For this reason i give the follwoing entry in "sqlnet.ora" :
    SQLNET.AUTHENTICATION_SERVICES=(NONE)

    Now when I run the script then it shows the follwing error :

    [oracle@localhost RMAN]$ sh rman.sh.copy

    Recovery Manager: Release 10.1.0.3.0 - Production

    Copyright (c) 1995, 2004, Oracle. All rights reserved.

    RMAN-00571: ================================================== =========
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ================================================== =========
    RMAN-00554: initialization of internal recovery manager package failed
    RMAN-04005: error from target database:
    ORA-01031: insufficient privileges

    Now plz tell me where is the problem . If I make any mistake then plz inform me .....

    Thx
    -----

  2. #2
    Join Date
    May 2006
    Posts
    132
    RMAN needs to run as someone with SYSDBA privileges. However, Oracle Secure Backup provides the ability to limit backup privileges.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •