Limiting access to specific fields in a database file

 

You can restrict update and read requests to the specific fields in a database file.

Use one of the following ways to limit access to the specific fields in a database file:

• Create a logical view of the physical file that includes only the fields to which you want your users to have access.

• Use the SQL GRANT statement to grant update authority to specific columns of a Structured Query Language (SQL) table.

 

Parent topic:

Securing database files

 

Related concepts

Using logical files to secure data
SQL programming