Row-level access control

Row-level access control enables the Database Owner or table owner to create a secure data access environment automatically, by providing:

Row-level access control restricts access to data in a table’s individual rows, through three features:

Adaptive Server enforces row-level access control for all data manipulation languages (DMLs), preventing users from bypassing the access control to get to the data.

The syntax for configuring your system for row-level access control is:

sp_configure "enable row level access", 1

This option slightly increases the amount of memory Adaptive Server uses, and you need an ASE_ASM license option. Row-level access control is a dynamic option, so you do not need to reboot the SQL Server.