Grant Login Access using T-SQL 1

[Ovatvvon]

Hi All,

I used the following code to add a login to the SQL Server:

CREATE LOGIN [{domain}\{user_id}] FROM WINDOWS WITH
	DEFAULT_DATABASE = {db_name},
	DEFAULT_LANGUAGE = us_english

which did grant the login access to the DBMS, however, I'm looking for a piece of code that will grant access for the specified ID to a specific database, with specific permissions (such as db_datareader / read-only).

I have not been able to find the right piece of code to do this.

Can anyone help?


-Ovatvvon :-Q

 

[ptheriault]

This is what your looking for now.

USE MyDB
GO
CREATE USER [user] FOR LOGIN [user] WITH DEFAULT_SCHEMA=[dbo]
GO
EXEC sp_addrolemember 'db_datareader', 'user'

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Ovatvvon]

Thanks Paul, I'll give that a try!

-Ovatvvon :-Q