sp_auth_sys_role_info system procedure

Returns the mapping of authorities from previous versions of SQL Anywhere to their corresponding compatibility roles.

Syntax

sp_auth_sys_role_info( )

Result set

Column	Type	Description
auth	VARCHAR(20)	The name of the authority.
role_name	CHAR(128)	The name of the corresponding compatibility role.
role_id	UNSIGNED INTEGER	The ID number for the compatibility role.

Remarks

Privileges

Standards and compatibility

Example

The following statement returns the list of authorities (auth) from pre-16.0 SQL Anywhere versions, mapped to their corresponding compatibility roles (role_name) provided as of version 16.0.

CALL sp_auth_sys_role_info();

auth	role_name	role_id
DBA	SYS_AUTH_DBA_ROLE	2147485648
RESOURCE	SYS_AUTH_RESOURCE_ROLE	2147485649
BACKUP	SYS_AUTH_BACKUP_ROLE	2147485650
VALIDATE	SYS_AUTH_VALIDATE_ROLE	2147485651
READFILE	SYS_AUTH_READFILE_ROLE	2147485652
PROFILE	SYS_AUTH_PROFILE_ROLE	2147485653
READCLIENTFILE	SYS_AUTH_READCLIENTFILE_ROLE	2147485654
WRITECLIENTFILE	SYS_AUTH_WRITECLIENTFILE_ROLE	2147485655
WRITEFILE	SYS_AUTH_WRITEFILE_ROLE	2147485656
REMOTE DBA	SYS_RUN_REPLICATION_ROLE	2147485664

Discuss this page in DocCommentXchange.