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]

Comments

Popular posts from this blog

Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c

Oracle 10g/11g Linux:SMS the alert logs ORA- errors generated in timestamp

Oracle 11g: Install Instant Client 11.2.0.3.0 on Linux x86_64 Server.