Databases Reference
In-Depth Information
11
Chapter
Users and Security
In This Chapter
Creating user accounts
◆
Assigning user account characteristics
◆
Creating and assigning profiles
◆
If a company has more than one employee who needs access to the Oracle
database, then the security of the database is a prime concern for the DBA.
The data integrity of the database and the level of security in the database
are maintained, in part, by preventing unauthorized or unintentional
actions in the database.
Database security can be divided into roughly two areas: data security
and system security. Data security includes monitoring and assigning
users permissions to the various objects in the database. System security
covers the user login process, how much disk space is assigned to each
user, and what kinds of actions each user can perform.
Creating and assigning roles
◆
Granting and revoking system and
object privileges
◆
Statement and object auditing
◆