-
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
-
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
-
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
-
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.
-
why do you need a users id to migrate a database - thats all done at the system level
-
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
-
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"
-
the alter user thing works in all versions
-
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)
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|