A list of the system privileges and object permissions
required to complete the various
login mapping tasks.
Creating a Login Mapping
Database Version |
Login Mapping Privileges |
SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- USER ADMIN authority along with SELECT permission on the
SYSLOGINMAP view.
|
SAP Sybase IQ
16.0 |
Requires MANAGE ANY USER system privilege along with one of:- SELECT ANY TABLE system privilege.
- SELECT permission on the SYSLOGINMAP
view.
|
Deleting a Login Mapping
Database Version |
Login Mapping Privileges |
SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- USER ADMIN authority along with SELECT permission on the
SYSLOGINMAP view.
|
SAP Sybase IQ
16.0 |
Requires MANAGE ANY USER system privilege along with one of:- SELECT ANY TABLE system privilege.
- SELECT permission on the SYSLOGINMAP
view.
|
Generating Login Mapping DDL Commands
Database Version |
Login Mapping Privileges |
SAP Sybase IQ 15.3 and 15.4 |
Requires SELECT permission on the SYSLOGINMAP view. |
SAP Sybase IQ
16.0 |
Requires one of: - SELECT ANY TABLE system privilege.
- SELECT permission on the SYSLOGINMAP
view.
|
Viewing Login Mapping Properties
Database Version |
Login Mapping Privileges |
SAP Sybase IQ 15.3 and 15.4 |
View Login Mapping properties – Requires SELECT permission on the
SYSLOGINMAP view. Modify Login Mapping
comment – Requires one of:
- DBA authority.
- USER ADMIN authority along with SELECT permission on the
SYSLOGINMAP view.
|
SAP Sybase IQ
16.0 |
View any login mapping property page – Requires one of: - SELECT ANY TABLE system privilege.
- SELECT permission on the SYSLOGINMAP
view.
Modify a login mapping comment – - Requires MANAGE ANY USER system privilege along with one of:
- SELECT ANY TABLE system privilege.
- SELECT permission on the
SYSLOGINMAP view.
|