Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I work on a company that has straight IT security manners. I was hired as a Database Analyst in order to optimize some processes in our team. The problem is that I only have read and write permissions and I'm trying to work out in getting advanced permissions on the databases. Currently we have a lot of Databases in a single server and we can only work on a single Database, I was wondering if the BULK INSERT permission could be given to a single database or would that be permission to the whole server?

I've searched through the web about this but I got a little confused. This is what I found out. In order to use BULK INSERT I should have INSERT permission to the desired table or database and the ADMINISTER BULK OPERATIONS which is a server wide permission. If I was given ADMINISTER BULK OPERATIONS permission on the whole database and the INSERT permission on a single database, wouldn't I be able to only BULK INSERT in that single database, since I don't have INSERT permission on other databases?

Is it possible to restrict the use of BULK INSERT to a single database on a server that has multiple databases?

Sorry about the text wall, and thanks!

share|improve this question

1 Answer 1

up vote 4 down vote accepted

Ok folks,

I've asked this on Brazilian msdn forum as well and I got the answer (Forum discution: BULK INSERT por DATABASE ). The user Roberson Ferreira _ helped me. I imagine you can't read Portuguese so I will describe the answer here.

Answer: It doesn't matter if the ADMINISTER BULK OPERATIONS is server wise, I won't be able to BULK INSERT into a certain database if I don't have INSERT permission as well, INSERT permission is a database/table wise permission.

Also, the ADMINISTER BULK OPERATIONS is not going to give me any other permissions over the server or database, all I will be able to do is BULK INSERT in the database I have INSERT permission as well.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.