Oracle User Missing
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Oracle User Missing

  1. #1
    Join Date
    Sep 2008
    Posts
    6

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    better provide some evidence

  3. #3
    Join Date
    Sep 2008
    Posts
    6
    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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    thats not evidence - anyway, the view you want is dba_users

  5. #5
    Join Date
    Sep 2008
    Posts
    6
    When I connect with the user I want to delete and make a query to dba_users, its name doesn't appear..

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    then the user doesnt exist

  7. #7
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,966
    Quote Originally Posted by davey23uk
    then the user doesnt exist
    or possibly Jonroc edited a system table.
    this space intentionally left blank

  8. #8
    Join Date
    Sep 2008
    Posts
    6
    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.

  9. #9
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,966
    So if you try "create user oracle_des_usr identified by pwd;"
    What happens.
    this space intentionally left blank

  10. #10
    Join Date
    Sep 2008
    Posts
    6
    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
  •  



Click Here to Expand Forum to Full Width