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
Role Privilege
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
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
How to Resolve ORA-01031: Insufficient Privileges
ORA-01031 ORA-01031: Insufficient Privileges means that the current user did not use the right privilege to process the SQL statement. Since this error can be… Read More »How to Resolve ORA-01031: Insufficient Privileges