DBA Role, How and Why
DBA Role In Oracle database, DBA could be the most privileged role. Whenever we want to make a user to be the most dominant application… Read More »DBA Role, How and Why
How and Why
Oracle Parameter SESSIONS, How and Why
In this post, we'd like to talk about the following topics for you to manage SESSIONS parameter better. Default Value of SESSIONS How to Check… Read More »Oracle Parameter SESSIONS, How and Why
EM_EXPRESS_ALL, How and Why
EM_EXPRESS_ALL Whereas EM_EXPRESS_BASIC provides some basic privileges to monitor properties through EM, EM_EXPRESS_ALL, also an Oracle predefined role, has some more advanced privileges which enable… Read More »EM_EXPRESS_ALL, How and Why
EM_EXPRESS_BASIC, How and Why
Enterprise Manager (EM) Enterprise Manager (EM) is a graphical management tool that provides centralized capabilities of managing Oracle databases and servers. In recent releases, EM… Read More »EM_EXPRESS_BASIC, How and Why
SELECT_CATALOG_ROLE, How and Why
SELECT_CATALOG_ROLE Oracle designs several privileges and roles for users who want to query database dictionary views. Two of them are usually used by DBA to… Read More »SELECT_CATALOG_ROLE, How and Why
NLS_DATE_FORMAT, How and Why
NLS_DATE_FORMAT defines the display format of a datetime string, which can be set at various levels to meet business requirements. That is to say, NLS_DATE_FORMAT… Read More »NLS_DATE_FORMAT, How and Why
FAILED_LOGIN_ATTEMPTS, How and Why
Unlimited failed logon attempts is certainly convenient for developers and users to access the database, but it leaves a chance for brute force attack to… Read More »FAILED_LOGIN_ATTEMPTS, How and Why
USER$, How and Why
SYS.USER$ is a table which stores all user's password information. Generally, the table should be used only by Oracle internal system and not DBA. If… Read More »USER$, How and Why
USER_ASTATUS_MAP, How and Why
SYS.USER_ASTATUS_MAP provides a list of account status bit and their definitions. Let's see its content. In which, ASTATUS stands for "Account STATUS". SQL> show user… Read More »USER_ASTATUS_MAP, How and Why
DBA_USERS_WITH_DEFPWD, How and Why
The data dictionary DBA_USERS_WITH_DEFPWD tells us that the users who are still using their default passwords defined in table DEFAULT_PWD$. For example, we have some… Read More »DBA_USERS_WITH_DEFPWD, How and Why