OraFAQ Forum: Server Administration » Find out current user and password

Home » RDBMS Server » Server Administration » Find out current user and password

Thu, 27 April 2006 12:17

karl_eisner
Messages: 8
Registered: April 2006

Junior Member

Hi to all!

i have a question. is it possible to find out the username and password of the user current logged on?
thanks in advance!

karl

Thu, 27 April 2006 12:20

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Password in clear text?
Nope. You cannot.
You can get current users in v$session (gv$sesion for RAC)
and get their hashed password from dba_users

Thu, 27 April 2006 12:58

karl_eisner
Messages: 8
Registered: April 2006

Junior Member

hi!

then it isn't possibe to invoke a link out of oracle with the parameters user and password?

karl

Thu, 27 April 2006 20:03

andrew again
Messages: 2577
Registered: March 2000

Senior Member

yes, if you target database has a matching user/pass as your current login, then you can use:

CREATE DATABASE LINK hq CONNECT TO CURRENT_USER using 'hq';

Previous Topic:	Log_archive_dest_n
Next Topic:	Temporary tablespace

Goto Forum:

]

Current Time: Sun Jan 26 15:10:29 CST 2025