Microsoft SQL Server 2005/2008:Create Read Only User for Database.
1.Create Read Only User. CREATE LOGIN [ ROUser ] WITH PASSWORD=N''*****', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO 2.Grant VIEW DEFINITION Role to selected SCHEMA.Default Schema is DBO. USE DatabaseName GRANT VIEW DEFINITION ON SCHEMA:: dbo TO [ ROUser ] About Me