The bcp utility can be used to copy data, from a table or view into an operating system file, or from an operating system file into a table. To copy data from an operating system file into a table, a user must have INSERT permission on the table. To copy a table or view to an operating-system file, the user must have SELECT permission on the following:
For information about granting permissions, see Chapter 9, Managing Security.