Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » User security (roles and privileges)



There are three types of roles in the role-based security model: system roles, user-defined roles (which include user-extended roles), and compatibility roles.

You can view the roles and privileges a user has in Sybase Central by clicking the user and viewing the details that are displayed. You can also retrieve the details using the sp_displayroles system procedure. See sp_displayroles system procedure.

 See also

System roles
Compatibility roles
User-defined roles
User-extended roles
Role administrators
Configuring roles and privileges for a role (Sybase Central)
Configuring roles and privileges for a role (SQL)
Granting a role (Sybase Central)
Granting a role (SQL)
Revoking a role (Sybase Central)
Revoking a role (SQL)
Dropping a role (Sybase Central)
Dropping a role (SQL)