Permissions Required to Run BCP
No permissions are required to run the BCP command-line utility. However, to use BCP to copy data into a table, the user must be granted INSERT permission to the target table. To export data from a table, the user must be granted SELECT permission for the source table.
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
