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
System Privilege
Oracle Change User Password
Change User Password Periodically, you may like to change your own password for more protection. In fact, there're many ways that can change user's password… Read More »Oracle Change User Password
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
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
How to Resolve ORA-01952: system privileges not granted to
ORA-01952 Let's see some error patterns of ORA-01952. CREATE TABLE ALL PRIVILEGES UNLIMITED TABLESAPCE 1. CREATE TABLE Tried to take a privilege away from a… Read More »How to Resolve ORA-01952: system privileges not granted to
Grant Privilege Correctly
Granting vs Revoking Granting a valid privilege to a grantee is easy and can be repeated over and over again, even though the privilege has… Read More »Grant Privilege Correctly
How to Resolve ORA-00990: missing or invalid privilege
ORA-00990 There could be several error patterns of ORA-00990 when we tried to grant some privileges to a user. GRANT CREATE INDEX GRANT CREATE FUNCTION… Read More »How to Resolve ORA-00990: missing or invalid privilege
How to Resolve ORA-00942: table or view does not exist
ORA-00942 ORA-00942 means that SQL engine found no table or view in your usable scope. In other words, table or view does not exist. The… Read More »How to Resolve ORA-00942: table or view does not exist