Friday, March 23, 2012

Permissions to read error log.

I want to give developers permission to read the error log on the production
server. How can I do this without making them Administrator or
Securityadmin?"Eric w" <ewientzek@.hotmail.com> wrote in message
news:OfqjBDn8EHA.3260@.TK2MSFTNGP14.phx.gbl...
> I want to give developers permission to read the error log on the
production
> server. How can I do this without making them Administrator or
> Securityadmin?
>
Since this is a text file, I'd suggest creating a share pointing to the
"LOG" folder (should be in "Program Files\Microsoft SQL Server\MSSQL\LOG" if
you took the default installation path). Allow the developers RX permission
to the NTFS layer of that folder.
Stevesql

No comments:

Post a Comment