Siebel Data Warehouse Installation and Administration Guide > The Siebel ePharma 6.3 to 7.5 Analytics Bridge > Installation Process >

Authorization Properties Block Changes

Modify the Authorization Properties block.

To change the Authorization properties

  1. From the same Variable Manager window, double-click on Authorization Block.
  2. In the new window, change the initialization string as follows:

    3. Select 'GROUP', R.NAME

    from VALUEOF(TBO).S_RESP R, VALUEOF(TBO).S_PER_RESP P, VALUEOF(TBO).S_EMPLOYEE U

    where U.LOGIN=':USER' and U.ROW_ID=P.PER_ID and P.RESP_ID=R.ROW_ID


 Siebel Data Warehouse Installation and Administration Guide, Version 7.5, Rev. C 
 Published: 18 April 2003