-
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
-
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."
-
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
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|