Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2003
    Posts
    106

    Unanswered: Not able to access V$instance view from normal user

    Hi,

    I am not able to access v$instance view from normal user even though I have given SELECT_CATALOG_ROLE to the user.

    sys user has the table.

    Any idea how to grant access on v$instance to some normal user.
    Its urgent pl. help
    Sachi

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Hm ... v$instance is a public synonym of a sys owned view v_$instance. If you GRANT SELECT ON v_$instance TO PUBLIC, your user should be able to select data from v$instance.

  3. #3
    Join Date
    Jan 2003
    Posts
    106

    thanx

    Hi,

    That worked fine for V$INSTANCE view.

    Any idea why even after giving SELECT_CATALOG_ROLE to a normal user other dictionary based views like obj$,indsubpart$ tables are not accessible.
    Sachi

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Try
    GRANT select_catalog_role TO PUBLIC;
    Perhaps it'll help.

  5. #5
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Code:
    SELECT table_name
    FROM   dba_tab_privs
    WHERE  grantee = 'SELECT_CATALOG_ROLE'
    ORDER BY table_name;
    See if OBJ$ etc are in the list.

  6. #6
    Join Date
    Oct 2004
    Posts
    145
    Why would you give out access to v$ tables/views?

    Where I work, it has caused DBA's nothing but grief by developers having access to V$ tables. Rather than troubleshooting their code, they tend to try to troubleshoot the database. In some cases application requires specifi access to v$ tables/views and it should be limited as such.

    If your company policy is to give users full select access to the database you can give them "select any table" permission rather than trying to sort out access to v$ tables/views.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •