ORA-01031: privilégios insuficientes

Tomás,

Por favor, leia este link:

===============================================================

How to Resolve ORA-01031: Insufficient Privileges

by Ed ChenJune 24, 2020

F. Alter User

...

Tried to add some quota on tablespace to itself, but it lacks of some privileges.

SQL> show user
USER is "HR"
SQL> alter user hr quota unlimited on users;
alter user hr quota unlimited on users
*
ERROR at line 1:
ORA-01031: insufficient privileges

The right privilege in this case is ALTER USER.

SQL> show user
USER is "SYSTEM"
SQL> grant alter user to hr;

Grant succeeded.

Then we do it again.

SQL> show user
USER is "HR"
SQL> alter user hr quota unlimited on users;

User altered.

SQL> alter user oe account lock;

User altered.

As you can see, with ALTER USER privilege, the user not only can grant some quota to itself, but also can change other's status.

===============================================================

[]'s,

Fabio I.

Toda vez que acessar o Oracle SQL Developer tenho que utilizar a função:

alter USER cursoplsql QUOTA UNLIMITED ON USERS;

Contudo, não entendi ao certo as razões disso.