First page Back Continue Last page Graphics
…Principal Features…
Security
- Logon ID’s password protected
- Limits on disk and resource usage
- Table access requires privilege via GRANT
- Fine grained Auditing at session or object level
- Data encryption
Notes:
As we would expect in a multi-user database environment, Oracle provides many standard security features.
All logon userids are protected against unauthorized access either by an Oracle password or by the operating system.
Disk and system resources such as CPU time are protected. Disk usage is governed by assigning QUOTA on a tablespace; CPU resources are governed with profiles or with the Database Resource Manager.
Once logged into the database, privileges are needed to do anything. For example, to query a table created by another user, you will require SELECT privilege on that object. That can be granted by the object owner with a GRANT statement. Conversely, it can be taken away with the REVOKE statement.