TSQL to grant db_datareader and db_datawriter for MS SQL Server

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!

From stackoverflow

• use mydb
  go
  
  exec sp_addrolemember db_datareader, MYUSER 
  go
  exec sp_addrolemember db_datawriter , MYUSER 
  go
  

  casperOne : Of course, it's better to assign rights to groups/roles instead of individual users, but this does answer the question.

  cmsjr : Actually, db_datareader and db_datawriter are predefined database roles, so this is a case of assigning users to roles.

• 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!

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

  consultutah : Ask your own question ;-)

• 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 */