How to Revoke All Grants from User
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 Revoke All Grants from User
Privilege
How to Resolve ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke
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 »How to Resolve ORA-01981: CASCADE CONSTRAINTS must be specified to perform this revoke
DATAPUMP_IMP_FULL_DATABASE, How and Why
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_IMP_FULL_DATABASE, How and Why
DATAPUMP_EXP_FULL_DATABASE, How and Why
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 »DATAPUMP_EXP_FULL_DATABASE, How and Why
How to Resolve ORA-01418: specified index does not exist
ORA-01418 Tried to alter an index, but it failed with ORA-01418. SQL> alter index emp_emp_id_pk rebuild; alter index emp_emp_id_pk rebuild * ERROR at line 1:… Read More »How to Resolve ORA-01418: specified index does not exist
How to Resolve ORA-01919: role does not exist
ORA-01919 ORA-01919 means that Oracle cannot find any privilege you specified, so it turned to search for the name in roles, but still no luck.… Read More »How to Resolve ORA-01919: role does not exist
EXP_FULL_DATABASE, How and Why
EXP_FULL_DATABASE 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 »EXP_FULL_DATABASE, How and Why
IMP_FULL_DATABASE, How and Why
IMP_FULL_DATABASE 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 »IMP_FULL_DATABASE, How and Why
Oracle Predefined Role List All
Oracle Default Roles What is user role? An user role is a set of related privileges which are required to perform some aspect of tasks,… Read More »Oracle Predefined Role List All
GRANT EXECUTE on SYS Package to PUBLIC
We used the following SQL statement to retrieve and compose necessary GRANT statements for you to fix your compiler problems related to SYS's public packages,… Read More »GRANT EXECUTE on SYS Package to PUBLIC