Lockdown Profile: 

From 12c onwards we have new feature called lockdown profile to control the PDB level activities. It can be created in CDB container.  SQL> show con_name CON_NAME ------------------------------ CDB$ROOT SQL>…

Common Roles Vs Local Roles

Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Roles: Collection of privileges called role. In 12c we have 2 different types…

Common Grant Vs Local Grant

Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Grants: oracle12c have two variant of grants. They are: 1) Common grants 2)…