bcp Permissions

You need an Adaptive Server account and the appropriate permissions on the database tables or views, as well as the operating system files to use in the transfer to use bcp.

To copy:

Data into a table – have insert and select permission on the table.
A table to an operating system file – have select permission on:
- The table to copy
- sysobjects
- syscolumns
- sysindexes