How can an ordinary databasde user see what db hs ie connected to?
V$DATABASE is only viewable by DBAs, so how can a 'normal' user find which db he/she is connected to (using SQL).
Is this what you mean?
SQL> create user test identified by test;
SQL> grant connect to test;
SQL> connect test/test@mysid;
SQL> select * from global_name;
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!
Click Here to Expand Forum to Full Width