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.
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
Subscribe to:
Posts (Atom)

