+ Reply to Thread
Results 1 to 4 of 4
  1. 11-15-2001 05:09 AM #1
    amits
    amits is offline Member
    Join Date
    Oct 2001
    Posts
    127
    Can we give v$parameter access to Normal users and How?
    I have tried to give but it was giving below error.
    ERROR at line 1:
    ORA-02030: can only select from fixed tables/views
    Reply With Quote Reply With Quote
  2. 11-15-2001 05:14 AM #2
    dknight
    dknight is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    V$ views require DBA privileges.

    But if you are not changing the init.ora file, you could run a script that creates a table with the v$parameter information that users could view.
    David Knight
    OCP DBA 8i, 9i, 10g
    Reply With Quote Reply With Quote
  3. 11-15-2001 05:20 AM #3
    amits
    amits is offline Member
    Join Date
    Oct 2001
    Posts
    127
    Thanks,
    So only DBA can query the v$views.
    Reply With Quote Reply With Quote
  4. 11-15-2001 08:59 AM #4
    tycho
    tycho is offline Member
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234
    Hi,

    you can aso grant the select_catalog_role so than all dictonary tables can be accessed. Also the v$parameter view.

    HTH

    Tycho
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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