October 21, 2002 at 12:03 pm
whats the easiest way to Revoke all permissions from a Role?
October 21, 2002 at 12:04 pm
on all Tables that is.
October 21, 2002 at 4:03 pm
sp_msforeachtable 'REVOKE ALL ON ? FROM role'
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
October 21, 2002 at 4:54 pm
Alternatively you can drop them in the db_denyreader/writer - not exactly the same as revoke but often pretty handy.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply