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.
JDB JDBC
ODBC
SYJ Sybase Adaptive Server Enterprise
ProxyUserName='value'
Parameter |
Description |
|---|---|
value |
Specifies the alternate login name that can use a connection. |
None
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.
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:
SQLCA.DBParm="ProxyUserName='pikachu'"
Copy the syntax from the Preview page into your script.
