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 will be mutually exclusive
Whether such exclusivity will be at the membership level or activation level
User-defined role names cannot duplicate user names.
Avoid name-conflicts when you create user-defined roles by following a naming convention. For example, you could use the “_role” suffix for role names. Adaptive Server does not check for such restrictions.
If a role must have the same name as a user, you can avoid conflict by creating a new role, having it contain the original role, and then granting the new role to the user.
