Privilege

How to Resolve ORA-01700: duplicate username in list

by Ed Chen
April 6, 2023April 6, 2023

ORA-01700 Tried to grant a privilege to some users, but it failed with ORA-01700. SQL> grant create session to erpapp1, erpapp2, erpapp3, erpapp1; grant create… Read More »

How to Resolve ORA-01939: only the ADMIN OPTION can be specified

by Ed Chen
April 5, 2023April 4, 2023

ORA-01939 Tried to grant a system privilege to an user, but it failed with ORA-01939. SQL> grant select any table to sh with grant option;… Read More »

How to Resolve ORA-00993: missing GRANT keyword

by Ed Chen
April 4, 2023April 4, 2023

ORA-00993 Tried to grant an object privilege to an user, but it failed with ORA-00993. SQL> grant select on hr.employees to sh with admin option;… Read More »

How to Resolve ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

by Ed Chen
March 10, 2023February 15, 2023

ORA-28009 Tried to connect to a database, but it failed with ORA-28009. SQL> conn sys/password@orclpdb ERROR: ORA-28009: connection as SYS should be as SYSDBA or… Read More »

How to Resolve ORA-39109: Unprivileged users may not operate upon other users' schemas

by Ed Chen
February 1, 2023June 8, 2023

ORA-39109 Saw error ORA-39109 when we tried to export someone's data from the database. C:\Users\Administrator>expdp ERPAPP@APPDB1 schemas=FINAPP dumpfile=FINAPP-export.dmp logfile=FINAPP-export.log ... ORA-31631: privileges are required ORA-39109:… Read More »

How Oracle Check User Default Role

by Ed Chen
January 31, 2023March 20, 2023

User Default Role Making roles default to a user has some advantages, it automatically enables all privileges in the default roles when the user logs… Read More »

How Oracle Revoke All Privileges from User

by Ed Chen
December 2, 2022June 21, 2023

The Principle of Least Privilege At times, you see plenty of unnecessary privileges on user, this is because some privileged user accidentally granted nearly all… Read More »

How to Resolve ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke

by Ed Chen
December 1, 2022March 16, 2023

ORA-01981 Tried to revoke object privileges from an user, but it failed with ORA-01981. SQL> revoke all on HR.EMPLOYEES from OE revoke all on HR.EMPLOYEES… Read More »

DATAPUMP_IMP_FULL_DATABASE, How and Why

by Ed Chen
November 22, 2022August 31, 2023

DATAPUMP_IMP_FULL_DATABASE DATAPUMP_IMP_FULL_DATABASE is one of predefined roles in Oracle database, who provides a bunch of system and object privileges required to perform full database imports… Read More »

DATAPUMP_EXP_FULL_DATABASE, How and Why

by Ed Chen
November 21, 2022August 31, 2023

DATAPUMP_EXP_FULL_DATABASE DATAPUMP_EXP_FULL_DATABASE is one of predefined roles in Oracle database, who provides a bunch of system and object privileges required to perform full database exports… Read More »

JavaScript is not enabled. Please enable it and reload the page.