April 23, 2003 at 7:12 am
We have a third party vendor that wants access to our system logs. We want to grant them acces via enterprise manager to the SQL Server logs. We have contemplated a share on the log directory, but do not want that overhead on the system volume. We want to give access through enterprise manager to appease the third party vendor. We have tested the securityadmin server role which seems to work the best. Any other ideas?
April 23, 2003 at 8:43 am
Setup a job to copy and or email them. Give them access to the new location. Could easily be another server. You could even automate this to run every hour.
Steve Jones
April 23, 2003 at 3:09 pm
I found an undocumented extended stored procedure that may be an alternative to using the enterprise manager. In our case, we are going to allow access to the sql server logs via the enterprise manager with delivered sql server role. The following is the sql to view all of the sql server logs:
master..xp_readerrorlog
go
master..xp_readerrorlog 1
go
master..xp_readerrorlog 2
go
master..xp_readerrorlog 3
go
master..xp_readerrorlog 4
go
master..xp_readerrorlog 5
go
master..xp_readerrorlog 6
go
April 23, 2003 at 6:36 pm
Just share the log sub-folder and grant vendor with read-only permission at NT file level and let them open your log files with NotePad. Your NT administrator sure knows how to do it.
Edited by - Allen_Cui on 04/23/2003 6:37:22 PM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply