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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.