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 |
Create a role – you must have the MANAGE ROLES system privilege.Grant a role during standalone role creation – you
must have 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
Grant a system privilege during
standalone creation – you must have 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 |
You must have 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 |
You must have 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 |
You must have 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 |
Enable the Manage Roles option –
you must have one of:- Administrative rights over the role (role
administrator)
- MANAGE ROLES system privilege if the role has a
global role administrator
Add an underlying system role – you must have
the MANAGE ROLES system privilege.
Add an
underlying user-defined or compatibility role – you must have 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 |
Enable the Manage Roles option –
you must have one of:- Administrative rights over the role (role
administrator)
- MANAGE ROLES system privilege if the role has a
global role administrator
Add an underlying system role – you must have
the MANAGE ROLES system privilege.
Add an
underlying user-defined or compatibility role – you must have 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 |
You must have 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 |
You must have 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 |
You must have 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 |
You must have 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 |
You must have 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. |
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.
Modify a standalone role comment – you must have 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:
|