When the Interactive Reporting components are installed using the custom option, the installer prompts for whether or not to create the row‑level security tables and in what database.
If the Interactive Reporting components are installed using the express option, or it is elected not to create the row‑level security tables during a custom install, then the tables must be created manually. The Interactive Reporting document mentioned above can create the tables, the necessary SQL DDL can be created based on the table definitions found in this documentation, or the script that creates them during the install can be run. To locate these scripts, look on the install CD under the DATA directory, and then under the appropriate database brand or vendor. The script of interest is named CreateRLS.sql.
When creating the tables post-install, use the web-based Administration module to tell the system where the tables are located. The information required includes the data source name, the database type, the API used to access the database, and the database credentials needed to access the row‑level security tables.
There is also a setting to enable or disable the row‑level security feature. This setting is intended to enhance performance in systems where the feature is not needed. When disabled, no attempt is made to access these tables. The feature should always be enabled if data security is to be enforced.