-
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;
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|