-
Oracle User Missing
Hi!
I'm facing a strange situation with a user. I'm using Oracle 10g.
The first time I was creating a user y putted it in SYSTEM tablespace.
The user got SYSDBA privileges.
My problema is that I can log with this user in SQLPlus, but when I log with with SYS as SYSDBA the user doesn't appear... I want to delete this user but I don't know how.
Thanks in advance for any help.
-
better provide some evidence
-
When I connect in SQLPlus with SYSDBA privileges I cannot see the user when i perform the query SELECT * FROM ALL_USERS. However I can connect to SQLPlus with this user.
Thanks
-
thats not evidence - anyway, the view you want is dba_users
-
When I connect with the user I want to delete and make a query to dba_users, its name doesn't appear..
-
then the user doesnt exist
-
Originally Posted by davey23uk
then the user doesnt exist
or possibly Jonroc edited a system table.
-
I honestly don't know why this is happening. I've been searching system tables for users, and particularly this user but I haven't found it.
Let me be more practical:
I open a command line:
1. sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on MiÚ Sep 3 11:08:47 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL>
2. SQL> connect oracle_des_usr/passwd@desora as sysdba
Conectado.
SQL>
3. SQL> SELECT username FROM dba_users;
USERNAME
------------------------------
DESA
MDDATA
DIP
SCOTT
TSMSYS
DBSNMP
SYSMAN
MDSYS
ORDSYS
CTXSYS
ANONYMOUS
USERNAME
------------------------------
EXFSYS
DMSYS
WMSYS
XDB
ORDPLUGINS
SI_INFORMTN_SCHEMA
OLAPSYS
MGMT_VIEW
SYS
SYSTEM
OUTLN
22 filas seleccionadas.
SQL>
Even further I try to alter the current user:
4. SQL> revoke dba from oracle_des_usr;
revoke dba from oracle_des_usr
*
ERROR en lÝnea 1:
ORA-01917: el usuario o rol 'ORACLE_DES_USR' no existe
And it doesn't know it...
Thanks in advance to any solution or any idea to solve this.
-
So if you try "create user oracle_des_usr identified by pwd;"
What happens.
-
It creates a new user. Although having the same name has the erroneous one, it's a different user.
One of the things I've tried initially was to create a user with the same name, provide that user sysdba privileges and the delete it, but it didn't solve my problem.
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
|