## Record-level and column-level security

JReport Designer record-level security (RLS) and column-level security (CLS) allow you to control user access to different subsets of data, and ensure that people only see what they are supposed to see. This enables you to provide different users with different and appropriate contents.

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. 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 products 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). In JReport Designer, record-level security and column-level security are both based on the data source connection, which means that you do not have to set security information for each report.

Record-level security can be applied simultaneously to both connection and report scopes. Note that, if a report-scope security policy has already been applied to a report, it will override a connection-scope security policy applied to the data source connection. 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