Creating permissions and masks

A number of considerations need to be determined to decide the best way to create permissions or masks.

Creating permissions or masks when row or column access control is active

The job creating the permission or mask obtains an exclusive lock on the base table. If row or column access control is active, the base table is not allowed to be read until the creating of the permission or mask is complete. The applications reading the base table need to be ended until the permissions or masks are added.

Creating permissions or masks when row or column access control is not active

The job creating the permission or mask obtains an exclusive lock on the base table. However, the base table is allowed to be read until the row or column access control is activated. The applications reading the base table do not have to be ended.