Three tables implement the row‑level security features for Interactive Reporting Web Client and EPM Workspace. Because the tables can be populated in a manner appropriate to the site’s requirements, no predefined user interface to maintain the tables is provided as part of the Interactive Reporting product. However, the row_level_security.bqy can be modified to suit an ad hoc implementation of the row‑level security feature, and as a tutorial or test tool when setting up a production system. The only requirement is that the basic set of column definitions be retained. The sample Interactive Reporting document can be used in all cases as a reporting tool for the row‑level security data as the servers see it.
Implementing a secure data access environment using row‑level security requires an understanding of SQL. First, knowing how the database relationships are defined is critical. Second, specifying the restrictions is directly translated into the SQL ultimately processed at the database.