Access to v$views
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Access to v$views

  1. #1
    Join Date
    Oct 2000
    Posts
    449

    Access to v$views

    Hello:

    Have a user that's been given access to only connect and resource roles. Want to give access to v$views and stuff like dba_xxxxx and so on.. I am unable to recall the syntax and is going wrong..

    Thanks, ST2000

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    Depends on who you are and what you can do.


    SQL> conn sys/oracle@db00
    Connected.
    SQL> grant select on v$database to scott;
    grant select on v$database to scott
    *
    ERROR at line 1:
    ORA-02030: can only select from fixed tables/views


    SQL> grant select on dba_data_files to scott;

    Grant succeeded.

    SQL> connect system/manager@db00
    Connected.
    SQL> grant select on dba_users to scott;
    grant select on dba_users to scott
    *
    ERROR at line 1:
    ORA-01031: insufficient privileges;

  3. #3
    Join Date
    Oct 2000
    Posts
    449
    Simply want to be able to select any v$views and dba_..._... views.

    Thanks, ST2000

  4. #4
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    Log in as the user sys, and grant select privileges to the v_$
    eg.
    If you want to have access to v$session

    connect sys/MySecretSysPassword
    grant select on v_$session to MyPersonalUser

    HTH
    Gert

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    (Since you don't mention your database release, I'll assume 9.*)

    GRANT SELECT ANY DICTIONARY TO your_user;

    And YOUR_USER has all V$ and DBA_* on his disposal, its as simple as that.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Oct 2000
    Posts
    449
    Hello:

    I am using 817.

    I am aware of granting permission 1 table.. But I want for ALL v$views and all dba_..._... views in one statement..

    Thanks, ST2000

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You can grant him/her SELECT_CATALOG_ROLE

    Sanjay

  8. #8
    Join Date
    Feb 2002
    Posts
    70
    grant select any table privilege to that user.

    The user can access v$tables and also dba_ tables.

    Thanks,
    ________________
    ShanDJ

  9. #9
    Join Date
    Apr 2002
    Posts
    291
    Shandj is correct,

    SQL> grant select any table to dloader;

    Grant succeeded.

    SQL> select name from v$database;

    NAME
    ---------
    CMSRPT1

    SQL> select count(*) from dba_tablespaces;

    COUNT(*)
    ----------
    20

    SQL> select count(*) from dba_data_files;

    COUNT(*)
    ----------
    60

    Its working for any v$tables and dba_tables....


    Thanks
    PNRDBA

  10. #10
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by shandj
    grant select any table privilege to that user.

    The user can access v$tables and also dba_ tables.
    And while you at that, why not simpl grant him DBA privilege? And perhaps SYSDBA on top of that? Or, to make it even more simple, why not simply all your user know the SYS password and let them all allways connect as SYS? You know, as DBA you'll have far less troubles with user managenment this way!
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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