Define an alternate login name and password by specifying the remote server to
create an external login for, and the local user the external login applies to.
Prerequisites
| Database Version |
External Login Privileges |
|---|
| SAP Sybase IQ 15.3 and 15.4 |
Requires one of:- DBA authority.
- USER ADMIN authority.
|
| SAP Sybase IQ
16.0 |
Requires MANAGE ANY USER system privilege. |
- The
SAP Sybase IQ resource is authenticated and running. (The
resource on which you are creating the external login).
Note: You must define a remote server before you can create an external login.
Task- In the Perspective Resources view, select the resource and
select .
- In the left pane, select .
- Click the arrow next to External Logins and select
New.
The Create External Login Wizard appears.
- On the Server and User page, specify:
| Option |
Description |
|---|
| Resource |
The resource (server) that the external login will be created on. |
| Remote Server |
The defined remote server which the external login will be used to connect
to. |
| User |
The defined local user for whom the alternate login name and password
(external login) will be created. |
- Click Next.
- On the External Login page, specify:
| Option |
Description |
|---|
| Login name |
The user ID to be used on the remote server by the previously selected
locally defined user. |
| Password |
The password for validating the user ID on the remote server. If the user
has no password on the remote server , leave it blank. |
| Confirm password |
If you enter a password, re-type it as verification. |
- Click Finish.