Check Privileges assigned to any Schema
Oracle Database allows several views that can be queried in order to obtain the list of privileges to any user, schema, role.
Oracle
Managing Oracle Instance
Oracle Database Startup Modes NOMOUNT MOUNT OPEN RESTRICT FORCE The first two( NOMOUNT and MOUNT) is known as maintenance mode. OPEN is general startup mode. Only DBAs can startup the instance in RESTRICT mode and access the database, other users […]
Unlock/Lock HR account in Oracle 11g
It is possible that you might forget to unlock the HR account while installation at the Password Management section. ALTER USER HR ACCOUNT UNLOCK IDENTIFIED BY S0m3P@ssw0rD; In order to execute this command, the user must have privilege of SYSDBA. For […]