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.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.