TSQL to grant db_datareader and db_datawriter for MS SQL Server

Question

What is the exact SQL to assign db_datareader and db_datawriter roles to a user in SQL Server?

Say the user name is MYUSER and the DB in question is MYDB.

Thanks!

Answer 1

use mydb
go

exec sp_addrolemember db_datareader, MYUSER 
go
exec sp_addrolemember db_datawriter , MYUSER 
go

Answer 2

I think casperOne means Active Directory type groups/roles which users can be added to easily. Of course, if your model uses SQL Security, this is a moot point.

In any case, this was exactly what I was looking for. Thanks!

Answer 3

Using this permission only Tables can be viewed and edit. what are the permission to modify Stored procedures, functions, etc Please ...

Answer 4

That's ok if its on the wrong question here is the answer:

GRANT EXECUTE to MYUSER ; /* Grant to all store procs */
GO
GRANT EXECUTE ON USP_LOADSOMEDATA TO MYUSER; /* Grant to as specific store procs */