What is a role?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is a role?

Rating:

A role is a named group of privileges such as object, system, and role privileges, which can be granted to a user or to another role. A user can be assigned several roles, and a single role can be granted to several users. A role is created using the CREATE ROLE statement.

Syntax:

CREATE ROLE role
[ NOT IDENTIFIED
| IDENTIFIED { BY password | USING [schema .] package | EXTERNALLY | GLOBALLY }
];

Rating: