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

Thread: 3rd party apps

  1. #1
    Join Date
    Feb 2007
    Posts
    212

    3rd party apps

    Hi,

    I'm a dba and I want to connect to one of my users apps schema without
    knowing her/his password. How do I do it?

    like connect scott.

    Is it grant become user to system?


    Thanks

  2. #2
    Join Date
    Feb 2007
    Posts
    1
    Hi,

    Connect to the database with the user who is having DBA roles and change the password of your user in off peak hours(when user is not there). Then perform your activity and again set the original password by its value on the database.

    e.g.

    conn system/manager
    sql>select username,password from dba_users where username='SCOTT';

    USERNAME PASSWORD
    ------------------------------ ------------------------------
    SCOTT 7304D3DD7C141581

    SQL> alter user scott identified by dhaval;

    User altered.


    ----------- Perform your activities -----------------------

    SQL> alter user sdasari identified by values '7304D3DD7C141581';

    User altered.

    I hope this will solve your problem.

    Thanks

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    dangerous if the user tries to connect while you have changed your password

    why do you need to connect as the user? as a dba you can see all their objects

  4. #4
    Join Date
    Feb 2007
    Posts
    212
    Thank u all ....i want to migrate it to 10g dear from 8i ...and I feel uncomfortable managing it from system userid.
    Last edited by jennifer2007; 02-12-2007 at 08:41 AM.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    why do you need a users id to migrate a database - thats all done at the system level

  6. #6
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    I am not sure that will work in 8i. In 7 works for sure but since some later release "identified by value" will work only with crate user but not with alter

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    is it some particular version ur talking of?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    the alter user thing works in all versions

  9. #9
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Dave, try that in 9i ( alter user .. IDENTIFIED BY VALUE I mean not just alter user. Alter user work for sure, but the ugly crack IDENTIFIED BY VALUE will not work in 9i for sure)

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    sorry to disappoint you but ..
    Code:
    SQL> create user test2 identified by test2;
    
    User created.
    
    SQL> grant create session to test2;
    
    Grant succeeded.
    
    SQL> select password from dba_users where username = 'TEST2';
    
    PASSWORD
    ------------------------------
    2E3197EF1322CB1D
    
    SQL> alter user test2 identified by test5;
    
    User altered.
    
    SQL> connect test2/test5
    Connected.
    SQL> connect / as sysdba
    Connected.
    SQL> alter user test2 identified by values '2E3197EF1322CB1D';
    
    User altered.
    
    SQL> connect test2/test2
    Connected.
    SQL> connect / as sysdba
    Connected.
    SQL> select * from v$version;
    
    BANNER
    ----------------------------------------------------------------
    Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
    PL/SQL Release 9.2.0.5.0 - Production
    CORE    9.2.0.6.0       Production
    TNS for Linux: Version 9.2.0.5.0 - Production
    NLSRTL Version 9.2.0.5.0 - Production

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