ERROR: You do not have SELECT priviledges on sys.V_$PARAMETER view.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • 2desperate2usedesperate
    New Member
    • Aug 2009
    • 5

    ERROR: You do not have SELECT priviledges on sys.V_$PARAMETER view.

    ERROR: You do not have SELECT privileges on sys.V_$PARAMETE R view. This process cannot proceed.

    Hello,
    I am using ORACLE 10g Standard Edition and I am trying to configure the Oracle Designer for which a repository must be installed. The following is the procedure I am following:
    • START >
    • PROGRAMS >
    • ORACLE
    • DEVELOPER SUITE –DevSuite1 >
    • DESIGNER >
    • REPOSITORY ADMINISTRATION UTILITY


    I am connecting to the database from which the repository will be formed. So I enter the following
    Enter the following

    Username: SYSMAN

    Password: password

    Connect String: orcl

    When I login to the Repository Administration Utility,
    I click "Install" and I follow by clicking all the affirmatives. (see attachment)





    So this is what I do after:
    1. I Open up command prompt

    2. ENTER: sqlplus sys/change_on_insta ll@orcl as sysdba

    And I receive the following:

    SQL*Plus: Release 10.1.0.4.2 - Production on Sat Nov 7 14:04:41 2009

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    ERROR:
    ORA-01031: insufficient privileges

    Enter user-name
    :

    -----------------------------


    SO I then enter the username:
    Enter user-name[/I]:SYSMAN
    Enter password: ********


    and this is the outcome:
    Connected to:
    Oracle Database 10g release 10.2.0.1.0 - Production

    SQL>




    I then enter:
    GRANT SELECT ON sys.V_$paramete r to SYSMAN;



    and I receive this:
    GRANT SELECT ON sys.V_$paramete r to SYSMAN;
    *
    ERROR at line 1:
    ORA-10301: Insufficient Privileges




    Can anyone tell me what I am doing wrong, please?
    (I'm not experienced in using Oracle)
    Thanks in advance!!!
    Attached Files
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    to grant previlages on sys objects you must login as sys.

    Comment

    Working...