Allow ROLE to SELECT from a single table

• Express12

  SSCoach

  Points: 18514

  More actions

  May 20, 2010 at 6:55 am

  #232677

  Simple question: what is the T-SQL to allow a ROLE to have SELECT on a specific table?

  DBName = MyDB

  TableName = MyTable

  ROLE = MyRole

  (I can do this thru SSMS 2008 GUI.. also need T-SQL)

  BT

• Abhijit More

  SSCertifiable

  Points: 6897

  More actions

  May 20, 2010 at 7:06 am

  #1170086

  you can also generate the script from GUI...

  GRANT SELECT ON [dbo].[MyTable] TO [MyRole]

  Abhijit - http://abhijitmore.wordpress.com