Security Guide

Back Next

Adding Column Level Security

Configure column level security with the infacmd sql SetColumnPermissions command. You cannot set column level security from the Administrator tool.

An Employee table contains FirstName, LastName, Dept, and Salary columns. You enable a user to access the Employee table but restrict the user from accessing the salary column.

To restrict the user from the salary column, disable the Data Integration Service and enter an infacmd similar to the following command:

infacmd sql SetColumnPermissions -dn empDomain -sn DISService -un Administrator -pd Adminpass -sqlds employee_APP.employees -t Employee -c Salary gun -Tom -dp SQL_Select

The following SQL statements return NULL in the salary column:

Select * from Employee
Select LastName, Salary from Employee

The default behavior is to return null values.

Column Level Security

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Security Guide

Security Guide

Adding Column Level Security

Adding Column Level Security