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!