Previous Topic: REPORT StatementNext Topic: Limiting Access to Database Tables


Securing Data Access for DQL Use

Securing access to your company's data is a major part of assuring data integrity. If you determined (using the USERS administrative option) that all users are to have unlimited read-only access, they can access all tables, rows, and columns in your database that are not protected by conditions and restrictions. If you do not authorize users for unlimited read-only access, each user can access only those tables (and their rows and columns) that you specifically assign to them.

Summary

This section describes the concepts of assigning users to specific tables, rows, and columns. It also describes how to limit the users' ability to manipulate the data accessed. This section applies only to DQL Mode.

Note: For information about SQL data access, see Securing Data Access for SQL Use.