-
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
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
|