Security Mechanisms : The Oracle Server provides discretionary access CONTROL, which is a MEANS of RESTRICTING access to information BASED on privileges. The appropriate privilege must be assigned to a user in order for that user to access an object. Appropriately PRIVILEGED users can grant other users privileges at their discretion; for this reason, this type of security is called “discretionary”.

Oracle manages database security using several different facilities:

• database users and schemas
• privileges
• roles
• storage settings and quotas
• resource limits
• auditing

Security Mechanisms : The Oracle Server provides discretionary access control, which is a means of restricting access to information based on privileges. The appropriate privilege must be assigned to a user in order for that user to access an object. Appropriately privileged users can grant other users privileges at their discretion; for this reason, this type of security is called “discretionary”.

Oracle manages database security using several different facilities: