Showing posts with label Grant or Revoke Permissions for all the table. Show all posts
Showing posts with label Grant or Revoke Permissions for all the table. Show all posts

Thursday, August 27, 2009

Grant or Revoke Permissions for all the table

To Grant or Revoke permission for all the objects at a single stroke

Exec sp_MsForEachTable 'Grant Select on ? to Guest'

Remember it will be work for Ms-sql 2005 or more, if 2000 it can be achieved by using while and dynamic sql.