Creating and assigning roles to users

Roles are collections of privileges that allow the role assignee to perform their job. The roles supported by Adaptive Server let you enforce individual accountability. Adaptive Server provides system roles, such as system administrator and system security officer, and user-defined roles, which are created and granted to users, login profiles, or other roles by a system security officer. Object owners can grant database access as appropriate to a role.

The final steps in adding database users are assigning them special roles, as required, and granting permissions. For more information on permissions, see Chapter 6, “Managing User Permissions.”