Exforsys
+ Reply to Thread
Results 1 to 3 of 3

ORA-01031: insufficient privileges

This is a discussion on ORA-01031: insufficient privileges within the Oracle Database forums, part of the Database category; Hi: I'm new user of oracle9i DBA, when i try to login Hr account I receive error" ORA-01031: insufficient privileges. ...

  1. #1
    Masroor Hussain is offline Junior Member Array
    Join Date
    Dec 2007
    Answers
    3

    ORA-01031: insufficient privileges

    Hi:
    I'm new user of oracle9i DBA, when i try to login Hr account I receive error" ORA-01031: insufficient privileges.
    So please help me.

    Last edited by admin; 12-31-2009 at 10:23 AM.

  2. #2
    imran_2010 is offline Junior Member Array
    Join Date
    Jan 2010
    Answers
    1
    Hi,

    Hope to find you well......Well give the following Privileges to HR User, then try to login.
    > Connect
    > Resource

    you can user the following Command:

    SQL> Grant Connect, Resource to HR;

    Regards,
    Imran


  3. #3
    mohiuddin is offline Junior Member Array
    Join Date
    Sep 2009
    Answers
    1
    Quote Originally Posted by Masroor Hussain View Post
    Hi:
    I'm new user of oracle9i DBA, when i try to login Hr account I receive error" ORA-01031: insufficient privileges.
    So please help me.
    Hi,
    Hope u r doing well. First u need to check whether the user account status such as expired or locked. If any of such situation is found then, unlock the user account,
    Should be login as sysdba privilege.
    > alter user hr account unlock;
    >alter user hr identified by hr;
    > grant connect,resource to hr;
    >conn hr/hr.


    •    Sponsored Ads



Latest Article

Network Security Risk Assessment and Measurement

Read More...