Posts

Showing posts from July 2, 2012

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