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 Adaptive Server 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 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 tab 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 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 tab 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 tab:
SQLCA.DBParm = "ProxyUserName = 'pikachu'"
Copy the syntax from the Preview tab into your script.
