Bookshelf Home | Contents | Index | PDF     

Oracle® Business Intelligence Presentation Services Administration Guide > Managing Oracle BI Presentation Services Security > Process of Authorizing Users to Act for Others >

Creating Session Variables for Proxy Functionality

This task is a step in Process of Authorizing Users to Act for Others.

There are two session variables along with their associated initialization blocks that you create to authenticate proxy users:

Session Variable
Associated Initialization Block

PROXY

Initialization Block Name: ProxyBlock

Initialization String Example:

select targetId
from Proxies
where 'VALUEOF(NQ_SESSION.RUNAS)'=targetId and ':USER'=proxyId

(Note that you will need to modify this SQL according to the schema of your database.)

PROXYLEVEL (optional)

NOTE:  If you do not create PROXYLEVEL, restricted access is assumed.

Initialization Block Name: ProxyLevel

Initialization String Example:

select proxyLevel
from Proxies
where 'VALUEOF(NQ_SESSION.RUNAS)'=targetId and ':USER'=proxyId

(Note that you will need to modify this SQL according to the schema of your database.)

For more information on creating session variables, see the Oracle Business Intelligence Server Administration Guide.

  
Oracle® Business Intelligence Presentation Services Administration Guide Copyright © 2007, Oracle. All rights reserved.