User Management Concepts

This topic tells you some basic information about Oracle user accounts. To learn how to add user account using dbForge Studio for Oracle Security Manager, see Setting Up New User Account.

There are some basic account concepts in Oracle.

User Privileges

A user privilege is a right to execute a particular type of SQL statement, or a right to access another user’s object. There are two types of privileges: system privileges and object privileges. System privileges allow to perform a particular database operation or class of database operations. For example, CREATE PROCEDURE privilege allows user to create stored procedures, functions, and packages in his schema. Object privileges are privileges that can be granted on database objects. Each type of object has different privileges associated with it. To learn more about user privileges, refer to Oracle documentation.

Roles

A role groups several privileges and roles, so that they can be granted to and revoked from users simultaneously. Roles can be enabled and disabled per user. Default role is the role that is automatically enabled for a user when the user connects to Oracle server.

Profiles

Profiles are the named sets of resource limits. Oracle limits database usage and instance resources to whatever is defined in the user’s profile. To use resource profiles resource limits must be turned on for the database as a whole. Profile can be assigned to each user.