SQL Function Changes

Function changes for SAP Sybase IQ 16.0.

System Functions
Function Description
sp_has_role New function. Returns an integer value indicating whether the invoking user has been granted a specified system privilege or user-defined role. When used for permission checking within user-defined stored procedures, this function can display an error message when a user fails a permission check.

See Reference: Building Blocks, Tables, and Procedures > SQL Functions > Alphabetical List of Functions> sp_has_role Function [System].

Parent topic: Behavior Changes
Related concepts
Backward Compatibility: Changes to Default Behavior
Backward Compatibility: Migration Considerations
Connection Changes
Database Option Changes
JRE and Java Runtime Environment Variable Changes
Logical Server Policy Option Changes
Login Policy Option Changes
Query Plan Changes
SQL Statement Changes
Stored Procedure Changes
Tables and Views Changes
Utility Option Changes
Discontinued Time Series SQL Functions