Monday, 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]