Data Warehouse provides some example files that ease the process of implementing security in Business Objects. There are files for both Oracle and SQL Server.

In your installation media, locate subfolder bo-universe/oracle/03_Security. In that folder, file how_to_make_WH_secured_universe_oracle.txt contains the necessary Oracle queries, plus some preceding comments that explain the other steps that are required to use the queries in a security strategy.

In installation media subfolder bo-universe/mssql/03_Security there is an equivalent file, how_to_make_WH_secured_universe_mssql.txt, with relevant instructions for SQL Server databases.