May 25, 2011 at 9:22 am
if a user is a local admin on a SQL server does he or she have rights to any folder on any of the drives or do explicit rights need to be given to the user on a particular folder?
Thanks.
May 25, 2011 at 9:29 am
If a login is member of the BUILTIN\Administrators group on the server no, specific permission should not be required.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 25, 2011 at 9:29 am
By default, they have rights on the machine, but you can set up folders that don't allow the administrator access. An admin can take access, but that is noted and audited, so that they cannot get into a folder inappropriately.
May 25, 2011 at 1:52 pm
You do not need an explicit access.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply