Database Administration (MOSC)

MOSC Banner

ORA-01031: insufficient privileges

edited Jul 3, 2013 9:28PM in Database Administration (MOSC) 7 commentsAnswered
That error has been displayed through this scenario:
SQL> select username, account_status from dba_users

USERNAME                                               ACCOUNT_STATUS
-----------------------------------------------------------------------------------------
SCOTT                                                      EXPIRED & LOCKED
XS$NULL                                                  EXPIRED & LOCKED

SQL> alter user scott identified by scott account unlock;

User altered.

SQL> alter user xs$null identified by xs$null account unlock;
alter user xs$null identified by xs$null account unlock
                                                 *
ERROR at line 1:
ORA-01031: insufficient privileges

SQL>

please help me with this matter thanks in advance! :P

Regards,
Nuggets_05

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center