## Record-level and column-level security

The record-level security (RLS) and column-level security (CLS) of JReport Designer allow you to control user access to different subsets of data and ensure that people only see what they are supposed to see: record-level security allows you to define which records are to be revealed to any given user, while column-level security allows you to define which report column is revealed to any given user. This enables you to provide different users with accordingly different, but appropriate contents. No matter to whom you need to provide information, a plant manager or thousands of customers, JReport Designer allows you to control access to information according to your requirements.

JReport Designer have two types of the security policies, one is a security policy based on a data source connection (connection-scope security policy), and the other is a security policy based on a single report (report-scope security policy). Record-level security can be applied simultaneously to both connection and report scopes. However, if a report-scope security policy has already been applied to a report, it will override a connection-scope security policy applied to the report. That is, report-scope security policies have a higher priority than connection-scope security policies.

Pick a topic from the following to get details about the security policy:

- Connection-scope security
- Report-scope security