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 |
You must have one of:- DBA authority
- USER ADMIN authority along with SELECT permission on the SYSLOGINMAP view
|
| SAP Sybase IQ
16.0 |
You must have the 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 |
You must have one of:- DBA authority
- USER ADMIN authority along with SELECT permission on the SYSLOGINMAP view
|
| SAP Sybase IQ
16.0 |
You must have the 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 |
You must have SELECT permission on the SYSLOGINMAP view. |
| SAP Sybase IQ
16.0 |
You must have 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 – you must have SELECT permission on the
SYSLOGINMAP view. Modify Login Mapping comment – you must have 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 – you must have one of: - SELECT ANY TABLE system privilege
- SELECT permission on the SYSLOGINMAP view
Modify a login mapping comment – you must
have the MANAGE ANY USER system privilege along with one of: - SELECT ANY TABLE system privilege
- SELECT permission on the SYSLOGINMAP view
|