revoke role sysdba does not affect
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: revoke role sysdba does not affect

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Posts
    120

    revoke role sysdba does not affect

    HI GURU'S,

    grant sysdba to saurabh;
    sqlplus "saurabh/saurabh as sysdba"
    SQL*Plus: Release 9.2.0.1.0 - Production on Tue Dec 24 19:42:26 2002

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production

    SQL>exit

    sqlplus "/ as sysdba"

    SQL> revoke sysdba from saurabh;

    Revoke succeeded.

    sqlplus "saurabh/saurabh as sysdba"

    --IT AGAIN CONNECT -- WHY --
    I DELETED MY PASSWORD FILE AND RECREATED THE FILE.
    orapwd file=C:\oracle\ora92\database\PWDtest.ora password=saurabh2 entries=2

    SO KNOW ONLY SYS CAN ACCESS THIS DATABASE AS SYSDBA
    BUT
    WHEN I AGAIN LOGGED IN WITH SAURABH


    sqlplus "saurabh/saurabh as sysdba"
    SQL*Plus: Release 9.2.0.1.0 - Production on Tue Dec 24 19:42:26 2002

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production

    SQL>exit




    ---------------------------------
    I CANT UNDERSTAND WHY THIS IS HAPPENING AND HOW CAN I RESOLVE IT.


    DATABASE VERSION IS 9.2.0.1 RELEASE 2
    Saurabh Garg
    OCP 9i

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    its working on myside ??

    regards
    Amar

    --------------------------------------------------------------
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    SQL>
    SQL> sho user
    USER is "SYS"
    SQL>
    SQL>
    SQL>
    SQL>
    SQL> create user revoke_test identified by manager
    2 default tablespace users;

    User created.

    SQL> grant connect,resource,sysdba to revoke_test;

    Grant succeeded.

    SQL> conn revoke_test as sysdba
    Enter password:
    Connected.
    SQL>
    SQL>
    SQL> connect sys as sysdba
    Enter password:
    Connected.
    SQL> revoke sysdba from revoke_test;

    Revoke succeeded.

    SQL> conn revoke_test as sysdba
    Enter password:
    ERROR:
    ORA-01031: insufficient privileges


    Warning: You are no longer connected to ORACLE.
    SQl>
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

    Re: revoke role sysdba does not affect

    Originally posted by saurabhg29

    I CANT UNDERSTAND WHY THIS IS HAPPENING AND HOW CAN I RESOLVE IT.
    DATABASE VERSION IS 9.2.0.1 RELEASE 2 [/B]
    Its because your sqlnet.ora setting. Comment SQLNET.AUTHENTICATION_SERVICES= (NTS) prameter from sqlnet.ora and then it will work.. When set to NTS, it uses windows native authentication and thus even though you revoke sysdba privilege it works.

    Sameer

  4. #4
    Join Date
    Sep 2001
    Posts
    120
    thanks
    Saurabh Garg
    OCP 9i

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