Creating roles

A role is a set of privileges. When the same set of privileges have to be assigned to all users, we create a role with all the required privileges and then assign this role to the users. We can assign a role to users or other roles. This recipe covers the creation of roles.

Getting ready

We must possess the ROLE ADMIN system privilege to grant roles to other roles and users.

How to do it…

Roles can be created in two ways: the GUI method or the SQL code, just as we did for user creation in the previous recipe. This section covers how to create roles using the GUI method.

Let's follow the given steps:

1. Expand the Security folder in the system where a role has to be created.

2. Expand the Roles menu, right-click on Roles, and click on New Role, as shown in the following screenshot:

3. In the next screen, give the name of the role to be created. Assign the required roles/privileges that this role should hold.

4. Click on Execute. This will produce a pop-up message that states Role successfully created...