SQL server 2008 Exp

Hansa,

I would check out this tip:

http://www.mssqltips.com/sqlservertip/1138/giving-and-removing-permissions-in-sql-server/

Please let me know if this answers your question.

Thank you,
Jeremy Kadlec

Is there anyway I can create a Group within sql 2008.

For example: to give read only permission to 'ApFin' (database name)

                    1. Create a 'Grp_ReadOnly'    

                    2. Add list of users already created from local Windows OS.

                    3. set 'Grp_ReadOnly' group to  read  'ApFin' database

Hansa,

If you want to give a group rights to read all tables and all views in a single database, I would suggest using db_datareader group.

I believe these are the steps you need to follow based on your follow-up question:

• Create the SQL Server "login" for the Windows group

CREATE LOGIN [domainName\loginName] FROM WINDOWS;
GO

• Grant the SQL Server login rights to the database which is called a SQL Server "user", even if it is a group

CREATE USER [loginName] FOR LOGIN [domainName\loginName] ;
GO

• Grant the SQL Server user rights to the db_datareader group

exec sp_addrolemember db_datareader, [loginName]
go

Let me know if this answers your question.

Thank you,
Jeremy Kadlec