Microsoft SQL Server forum - BULK INSERT and APPLICATION ROLE

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

BULK INSERT and APPLICATION ROLE

avicentic@gmail.com

2005-11-18, 7:23 am

I want to add bulkadmin permission to my applicatio role. Is it a
posible.
My windows account havo only public permission on database.

I'm using application role

EXEC sp_approlepassword 'MyRole', 'password';

Therefore I want to BULK some data with BULK INSERT command.
Error is:

The current user is not the database or object owner of table
'tablename'. Cannot perform SET operation.

Thanks in advance.

avicentic@gmail.com

2005-11-18, 9:23 am

In previous message I made a error. I am setting a aplication role by
command sp_setapprole instead sp_approlepassword

Sponsored Links