Menu
I'm getting ORA-01031: insufficient privileges when creating a package my own schema. Shouldn't I have complete control over my schema. If this is not the case, what privileges does my schema need?
745
ORA-01031: insufficient privileges Solution: Go to Your System User. then Write This Code: SQL> grant dba to UserName; //Put This username which user show this error message. Grant succeeded.
You see the Insufficient Privileges error if you don't have the right access on different levels. For example, your profile prevents you from accessing the account object, or your role prevents you from accessing a case record.
ORA-01031 Error Message “Insufficient Privileges” Error ORA-01031 means you are attempting to execute an operation for which you do not have appropriate privileges.
0 - Production SQL> create user u identified by u; Utilisateur créé. SQL> grant create session to u; Autorisation de privilèges (GRANT) acceptée. SQL> connect u/u Connecté. SQL> declare n number; 2 begin 3 execute immediate 'select count(*) from dual' into n; 4 end; 5 / Procédure PL/SQL terminée avec succès.
You may need to have GRANT CREATE PROCEDURE TO USERNAME.
53
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
