ProxyUserName database parameter
Description
Specifies that you want EAServer to retrieve a connection
from a connection cache by proxy.
This parameter applies only when a PowerBuilder
custom class user object is deployed as an EAServer component.
Controls
-
JDB JDBC
-
ODBC
-
SYJ SAP Adaptive Server Enterprise
Syntax
|
1 |
ProxyUserName='<span>value</span>' |
|
Parameter |
Description |
|---|---|
|
value |
Specifies the alternate login name that |
Default
None
Usage
Regardless of whether you access a cache by user or name,
you can retrieve a connection by proxy. Retrieving a connection
by proxy means that you can assume the identity and privileges of
another user by providing an alternative login name.
This feature can be used with any database that recognizes
the SQL command set
session authorization. In order for user A to use the
ProxyUserName parameter to assume the identity of another user B,
user A must have permission to execute this statement. For example,
for SQL Anywhere, user A must
have DBA authority, and for Adaptive Server Enterprise, user A must have
been granted permission to execute set session authorization by
a System Security Officer.
Using the SYJ interface
Sybase EAServer uses a slightly different version of the CT-Lib
software. Therefore, at runtime, you need to
use the SYJ database interface rather than ASE or SYC to connect
to an Adaptive Server Enterprise database. The SYJ Database Profile
Setup dialog box provides a convenient way to set the appropriate
connection parameters and then copy the syntax from the Preview page
into the script for your Transaction object.
You cannot use the SYJ interface, however, to connect to the
database in the PowerBuilder development environment. Therefore, during
the development phase (before the component has been
deployed to EAServer), you must use ASE or SYC to connect to the
database.
For information on how to use PowerBuilder to build EAServer
components and enable set-proxy support, see Application
Techniques.
Examples
On the EAServer page in the Database Profile Setup
dialog box, enter the alternative login name in the Proxy User Name
box. The PowerScript syntax for the ProxyUserName parameter displays
on the Preview page:
|
1 |
SQLCA.DbParameter="ProxyUserName='pikachu'" |
Copy the syntax from the Preview page into your script.