I have a non sysadmin login and I need it to be able to mount a remote disk by using
xp_cmdshell 'net use [...]'
When the login executes the command it seems to work but it doesn't really.
As well, this login can't read a disk mounted by a sysadmin login
Is there any server permission that allows the non sysadmin login to achieve this?
Thnks in advance,
Our Group Security dictates that personal information is classified as highly confidential, and as such, the regular DBA performing normal database admin tasks should be prevented from reading data in the database containing that data??