How all users access V$ Views ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: How all users access V$ Views ?

Hybrid View

  1. #1
    Join Date
    Dec 2000
    Posts
    32

    Question

    only the sys user can execute SELECTs from the
    V$ views and X$ tables.how to grant other database users access to the specific V$ views or X$ tables ?Any help would be appreciated.

  2. #2
    Join Date
    Dec 2000
    Posts
    11
    The sys user and users granted the dba role or the select_catalog_role role can see the dynamic views. To be able to 'execute' a select (plsql?) you'll need to grant dml privs directly to a user (as sys: grant select on v$_session to <user>;).

  3. #3
    Join Date
    Dec 2000
    Posts
    32

    Arrow granting select for a V$ view

    Shwa,

    I connected as system/manager and I want to grant select on v$database to user scott how would I do ? Is it something like
    grant select on v$database to system.scott ? I tried without system also.But giving an error saying table or view doesn't exist.

  4. #4
    Join Date
    Jun 2000
    Posts
    295
    as Oracle account sys do:
    grant select on SYS.V_$DATABASE to scott;

  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    it would be


    GRANT SELECT ON SYS.V_$DATABASE to scott.
    You have to be a sys or a dba to grant this access.

    Good luck.
    Sam

  6. #6
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Hi All those v$ tables are owned by SYS. So, login as SYS and and grant
    Thanks
    Kishore Kumar

  7. #7
    Join Date
    Dec 2000
    Posts
    32

    Programatic way to grant select

    Hi Kishore,

    It did work.Thanks.Can we do same thing in programatic way rather than using SQL*PLUS ? Thanks.

    ---Radha

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Most of the time it would be better to go manually and do the grant to avoid the security breaches. One of the way you could do it is write a shell script that would first set the env to point to the database and connect as internal and then run the grant and other DDL commands that you want and exit.

    Sam

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