Hi,
We need to invoke a single SQL statement after a user has connected with the database through Business Objects. The SQL statement will set the user’s role for data access and the BO reports requested will return data based on the user id and role. Is it possible to do this in Supervisor or Designer? We’re using BO 5.0.
Thanks, Dan
Dan6 (BOB member since 2004-10-06)
Dan,
you can do this in Supervisor using row-level restrictions. Have a search on the forums for the many entries relating to it.
Regards,
Mark
If you’re talking about security, you may find this helpful.
Steve Krandel 
(BOB member since 2002-06-25)
Thanks very much for your replies.
Just to clarify…We are using Oracle Views and Roles to provide security on 100+ tables used in various applications. When a database connection is issued with the proper userid id, the views on specific tables are set according to the userid and a default role is set by the Oracle. For an extra layer of security, the default role must be reset to another role by the user or application to allow access to the data. The “Set Role {rolename} As Identified by {password}” Oracle/PLSQL command is used. When Business Objects uses the login userid and password to connect to the database, we would like to issue the Set Role command after the database login/connection is issued. I’m not clear if Supervisor or Designer would provide this capability?
Dan
Dan6 (BOB member since 2004-10-06)