Re: how to verify current_schema?

Mladen Gogala wrote:
>
> There are several ways to do it:
> $ sqlplus /
>
> SQL*Plus: Release 10.1.0.2.0 - Production on Wed May 12 20:11:39 2004
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
>
> SQL> select sys_context('USERENV','SESSION_USER') from dual;
>
> SYS_CONTEXT('USERENV','SESSION_USER')
> --------------------------------------------------------------------------------OPS$MGOGALA
>
> SQL> show user
> USER is "OPS$MGOGALA"
> SQL> select user from dual;
>
> USER
> ------------------------------
> OPS$MGOGALA
>
> SQL>
> SQL> !whoami
> mgogala
>
> SQL>
>
> Also, you can do the following:
> begin
> DBMS_RTFM('CURRENT USER','USERNAME');
> end;
> /
>
> If you execute the procedure correctly, you'll get the desired result.
>

Mladen,

 Sorry to have to say that, but you need to give a look to your beloved manuals yourself. There is a difference between the current user, who determines what to you are allowed to do (although that in some old Oracle 7 version ... but I am erring) and the current schema, ie basically who is the default owner of the objects you reference when you don't specify this owner name explicitly. By default, the current schema IS the current user. But afterwards they can live independent lives. Jacques' was the correct answer.

-- 
Regards,

Stephane Faroult
Oriole Software
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------