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!