A list of the system privileges and object permissions
required to complete the various
role-based standalone role tasks.
Creating a Standalone Role
| Database Version |
Role-Based Standalone Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
Creating a role requires MANAGE ROLES system privilege.Granting a role during
standalone role creation requires one of: - Administrative rights over the role being granted (role
administrator).
- MANAGE ROLES system privilege if the role being granted has
a global role administrator.
Granting a system privilege during standalone creation
requires administrative rights over the system privilege being
granted.
|
Deleting a Standalone Role
| Database Version |
Role-Based Standalone Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
Requires one of:- Administrative rights over the role being deleted.
- MANAGE ROLES system privilege if the role being deleted has a
global role administrator.
|
Adding and Removing Grantees to and from a Standalone Role
| Database Version |
Role-Based Standalone Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
Requires one of:- Administrative rights over the role (role administrator).
- MANAGE ROLES system privilege if the role has a global role
administrator.
|
Changing a Grantee's Administrative Rights on a User-Extended Role
| Database Version |
Role-Based Standalone Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
Requires one of:- Administrative rights over the role (role administrator).
- MANAGE ROLES system privilege if the role has a global role
administrator.
|
Adding and Removing Underlying Roles to and from a Standalone Role
| Database Version |
Role-Based Standalone Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
To enable the Manage Roles option requires one of:- Administrative rights over the role (role administrator).
- MANAGE ROLES system privilege if the role has a global role administrator.
To then add an underlying system role requires MANAGE ROLES
system privilege.
To then add an underlying user-defined or
compatibility role requires one of: - Administrative rights over the underlying role (role
administrator).
- MANAGE ROLES system privilege if the underlying role has a
global role administrator.
|
Changing Administrative Rights on an Underlying Role of a Standalone Role
| Database Version |
Role-Based Standalone Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
To enable the Manage Roles option requires one of:- Administrative rights over the role (role administrator).
- MANAGE ROLES system privilege if the role has a global role administrator.
To then add an underlying system role requires MANAGE ROLES
system privilege.
To then add an underlying user-defined or
compatibility role requires one of: - Administrative rights over the underlying role (role
administrator).
- MANAGE ROLES system privilege if the underlying role has a
global role administrator.
|
Adding and Removing System Privileges to and from a Standalone Role
| Database Version |
Role-Based Standalone Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
Requires administrative rights over the system privilege. Administrative rights on the
role is not required. |
Changing Administrative Rights on a System Privileges Granted to a Standalone Role
| Database Version |
Role-Based Standalone Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
Requires administrative rights over the system privilege. Administrative rights on the
role is not required. |
Managing Role Administrators of a Standalone Role
| Database Version |
Role Administrator Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
Requires one of:- Administrative rights over the role being managed.
- MANAGE ROLES system privilege if the role being granted has a
global role administrator.
|
Adding the Global Role Administrator to a Standalone Role
| Database Version |
Global Role Administrator Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
Requires administrative rights over the role being managed. |
Removing the Global Role Administrator from a Standalone Role
| Database Version |
Global Role Administrator Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
Requires one of:- Administrative rights over the role being managed.
- MANAGE ROLES system privilege.
|
Generating Standalone Role DDL Commands
| Database Version |
Role-Based Standalone Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not supported. |
| SAP Sybase IQ
16.0 |
None required. |
Viewing or Modifying User-Extended Role Properties
| Database Version |
Role-Based Standalone Role Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Not Supported. |
| SAP Sybase IQ
16.0 |
View any standalone role property page – None required.
Modify a standalone role comment – Requires one of: - Administrative rights over the role being commented.
- MANAGE ROLES system privilege if the role being granted has
a global role administrator.
For privileges relating to standalone role permissions, see:
|