DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Connecting as SYSDBA failes on Sun, not on NT

  1. #1
    Join Date
    Jun 2002
    Posts
    1
    Folks,

    Context
    ---------
    Using Oracle9i, I have a program Pro*C program that connects as SYSTEM user. Then, it proceeds to create another userid and give it various priveleges. I also need to give the new userid SELECT privileges on tables owned by SYS.

    Solution
    ---------
    In order to GRANT SELECT to the SYS tables, my program does the following:

    EXEC SQL CONNECT :system_uid
    IDENTIFIED BY :system_pwd
    USING :local_db IN SYSDBA MODE ;

    Problem
    ---------
    This solution worked on the NT 2000 platform running Oracle 9.0.1.3. However, on the Sun platform, this same piece of code returns ORA-1031 (insufficient priveleges).

    Why this disparity?

    Please help.

    Thanks,
    Dan

  2. #2
    Join Date
    Apr 2002
    Posts
    291
    Hi

    Try to connect as "system/manager as sysdba" if you want to connect as SYS.

    So type -- as dba at your system_pwd

    For eg:

    sui: system
    sys_pwd: manager as sysdba

    This may work....

    Folks, Correct me if i'm wrong.

    Thanks
    PNRDBA

  3. #3
    Join Date
    Apr 2002
    Posts
    291
    I think you are trying to give select privileges being in system, to another user. ORA 1031 says--

    When you try to give privileges to another user which has got highier label than the connected one, then definitely it won't allow. Try connecting as sysdba, and then give select privileges.

    Thanks.
    PNRDBA

  4. #4
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    You should be sys to grant privs on sys.tables.
    Thanks.
    Thanigaivasan.

  5. #5
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Check this....
    $oerr ora 1031
    01031, 00000, "insufficient privileges"
    // *Cause: An attempt was made to change the current username or password
    // without the appropriate privilege. This error also occurs if
    // attempting to install a database without the necessary operating
    // system privileges.
    // When Trusted Oracle is configure in DBMS MAC, this error may occur
    // if the user was granted the necessary privilege at a higher label
    // than the current login.
    // *Action: Ask the database administrator to perform the operation or grant
    // the required privileges.
    // For Trusted Oracle users getting this error although granted the
    // the appropriate privilege at a higher label, ask the database
    // administrator to regrant the privilege at the appropriate label.

    Thanks.
    Thanigaivasan.

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