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.
Obsolete parameter
ProxyUserName parameter is obsolete, because EAServer is no longer supported since PowerBuilder 2017.
Applies to
ODBC
Syntax
ProxyUserName='value'
Default value
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.
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:
SQLCA.DBParm="ProxyUserName='pikachu'"
Copy the syntax from the Preview page into your script.
See also
