Access rules and bcp

Adaptive Server enforces access rules when data is copied out of a table using the bcp. Adaptive Server cannot disable access rules, as it does with alter table, because any user can use bcp who has select permission on the table.

For security purposes, the database owner should lock the table exclusively and disable access rules during bulk copy out. The lock disables access to other users while the access rules are disabled. The database owner should bind the access rules and unlock the table after the data has been copied.