ORA-01031: insufficient privileges
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-01031: insufficient privileges

  1. #1
    Join Date
    May 2008
    Posts
    23

    ORA-01031: insufficient privileges

    I have created one new user "balusu",for this user how to grant SYSDBA or SYSOPER privileges...



    SQL> grant sysdba to balusu;
    grant sysdba to balusu
    *
    ERROR at line 1:
    ORA-01031: insufficient privileges


    SQL> grant sysoper to balusu;
    grant sysoper to balusu
    *
    ERROR at line 1:
    ORA-01031: insufficient privileges


    SQL> shutdown normal;
    ORA-01031: insufficient privileges
    SQL> shutdown immediate;
    ORA-01031: insufficient privileges
    SQL> shutdown abort;
    ORA-01031: insufficient privileges
    SQL> shutdown
    ORA-01031: insufficient privileges
    SQL>

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Do you mind to refer oracle documentation? It has been told you many times by this forum. Please put some effort before coming here.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Mar 2001
    Location
    India
    Posts
    57
    Hi,

    It is indicating that granting user doesn't have permission to grant such privilages.

    Thanks and regards,
    Gitesh Trivedi
    Last edited by davey23uk; 08-23-2009 at 04:55 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width