DBA_SYS_PRIVS

How to Revoke All Privileges from User

by Ed Chen
December 2, 2022March 12, 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 »

DATAPUMP_IMP_FULL_DATABASE, How and Why

by Ed Chen
November 22, 2022March 13, 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, 2022November 22, 2022

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 »

EXP_FULL_DATABASE, How and Why

by Ed Chen
August 17, 2022October 20, 2022

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 »

IMP_FULL_DATABASE, How and Why

by Ed Chen
August 17, 2022March 20, 2023

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 »