v$session : username vs schemaname ?

Printable View

08-30-2002, 04:24 AM
htanga

Hi everybody !
Does someone know the difference between v$session.username and v$session.schemaname ?
Thanks a lot in advance ...
08-30-2002, 04:35 AM
anandkl

Here the schemaname=schema user name
username= oracle username and both should be the same.

regards
anandkl
08-30-2002, 04:45 AM
pando

username is the one who runs the query, schemaname is schema which the queries are run against to

for example

I am user SCOTT, when I logon I can do

alter session set current_schema=FORD;

Code:

SQL> select username, schemaname from v$session; USERNAME SCHEMANAME ------------------------------ ------------------------------ SYS SYS SYS SYS SYS SYS SYS SYS SCOTT FORD

Scott has table emp with 14 rows, Ford has empty table emp, now if I query emp as SCOTT but under schema FORD I will be querying FORD´s emp table and not SCOTTs
08-30-2002, 04:46 AM
SANJAY_G

It should be same except for background processes. For BG processes username is usually NULL and schemaname is SYS.

Sanjay
08-30-2002, 07:09 AM
nagarjuna

Quote:

Originally posted by SANJAY_G
It should be same except for background processes. For BG processes username is usually NULL and schemaname is SYS.

Sanjay

Hey, Sanjay pls do read the msg clearly before rasing your doubt again.. That was an excellent reply from Pando which clearly says the difference between username and shcema name in v$session. Read that message once again..
08-30-2002, 07:50 AM
jmodic

Quote:

Originally posted by nagarjuna
Hey, Sanjay pls do read the msg clearly before rasing your doubt again.. That was an excellent reply from Pando

Hey, nagarjuna pls note the time when pando's and Sanjay's messages were posted. You'll note that it is very likely that pando's reply was not published yet when Sanjay started writing down his comment. So there is no need to be harsh on him, simmilar things have happend to many of us....
08-30-2002, 10:39 AM
SANJAY_G

Thanks jmodic.

nagarjuna, I hope that clears your doubt.

Sanjay
08-30-2002, 10:55 AM
nagarjuna

Quote:

Originally posted by SANJAY_G
Thanks jmodic.

nagarjuna, I hope that clears your doubt.

Sanjay

oh.. I am very very sorry Mr. Sanjay. It was my mistake. Since, I am new to this forum (registered 8 hrs back), I didnt know abt this timing problem and flow of the forum. I am sorry once again.