leonvr (12/2/2008)
For BI I want read-only permissions on all sqlserver databases on a server. We will get this done. The problem is however that I have right to (accidentelly) shut down the server.
Someone who just needs read-only permission on some databases should not have remote access to the server at all. That should be reserved only for the admins.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability