How can an ordinary databasde user see what db hs ie connected to?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How can an ordinary databasde user see what db hs ie connected to?

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818

    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).

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    desc global_name

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,001
    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>

  4. #4
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    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
  •  



Click Here to Expand Forum to Full Width