Access rules and bcp

Adaptive Server enforces access rules when data is copied out of a table using the bulk copy utility (bcp). Adaptive Server cannot disable access rules, as it does with alter table, because bcp can be used by any user 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.