V$DATABASE is only viewable by DBAs, so how can a 'normal' user find which db he/she is connected to (using SQL).
V$DATABASE is only viewable by DBAs, so how can a 'normal' user find which db he/she is connected to (using SQL).
desc global_name
Is this what you mean?
SQL> create user test identified by test;
User created.
SQL> grant connect to test;
Grant succeeded.
SQL> connect test/test@mysid;
Connected.
SQL> select * from global_name;
GLOBAL_NAME
---------------------
MYSID.WORLD
SQL>
Of course! (Memory like a sieve).
And I'd used that a few weeks back so they could check when creating DB links. Thanks guys!