Give a user a role in T-SQL!

EXECUTE sp_addrolemember @rolename = N'db_datareader',
      @membername = N'YIN\Yang';