Before you implement user-defined roles, decide:
The roles you want to create
The responsibilities for each role
The position of each in the role hierarchy
Which roles in the hierarchy are mutually exclusive and if so, at the membership or activation level
Avoid name conflicts when you create user-defined roles by following a naming convention. For example, you can use the “_role” suffix for role names. Adaptive Server does not check for such restrictions.
The names of user-defined roles granted directly to users or to login profiles cannot duplicate the name of any login or login profile. If a role must have the same name as a user, avoid conflict by creating a new role, having it contain the original role, and then granting the new role to the user.
After you have planned the roles to create and the relationships among them, decide how to allocate roles according to business requirements and the responsibilities of your users.
The maximum number of roles that a user can activate per user session is 127.
The maximum number of user-defined roles that can be created server-wide is 992.
