Forums | Help | Site Map

Join Bytes
Login

network: 226,471 (2259 online)

bytes

Reg Database

shariquehabib shariquehabib is offline

shariquehabib is offline

Newbie

Join Date: Oct 2006

Location: Bangalore

Posts: 22

#1: Sep 15 '08

Can any one let me know sql quey to get loginname of databse/table thru which we logged in?

--
Sharique

r035198x is offline

Lives Here

Join Date: Sep 2006

Posts: 12,070

#2: Sep 15 '08

re: Reg Database

The password won't be available because it's not stored after log in. The user name is as easy as

Expand|Select|Wrap|Line Numbers

select user from dual

samir pradhan samir pradhan is offline

samir pradhan is offline

Newbie

Join Date: Jul 2008

Posts: 6

#3: Sep 19 '08

re: Reg Database

to view the user:

sql> show user

Reply

« previous question | next question »

Similar Oracle Database bytes

saving data to another database (answers)
Reg: database connectivity between SQL and ORACLE (answers)
Opening Another Database from WITHIN a Database (answers)
Allowing special characters in a MySql Database (answers)

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,471 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml

it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved