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.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?