
- Forum
- Database
- Oracle Database
- ORA-01031: insufficient privileges
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. ...
-
12-30-2009, 07:10 AM #1
- 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.
-
01-01-2010, 07:11 AM #2
- 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
-
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

Reply With Quote






