1

Topic: Resolution ADMINISTER BULK OPERATIONS through the certificate

Good afternoon!
Problem following. Is xml a file which opens in stored procedure through OPENROWSET. Accordingly, users need resolution ADMINISTER BULK OPERATIONS. Decided to make through the certificate. Created in the master the certificate, the name of an input compared with the certificate,  the certificate, recovered in the user DB, signed it stored procedure. But all the same resolution on the instruction of mass loading demands. What do I do not so?

2

Re: Resolution ADMINISTER BULK OPERATIONS through the certificate

Understood. By call OPENROWSET of the right of a name of the input created on the basis of the certificate, are eliminated from a dial-up of the rights of the current user. That it did not happen, the request with OPENROWSET is necessary for causing through dynamic SQL.