Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to grant all to all quickly
Message
From
26/01/2000 17:48:26
 
 
To
26/01/2000 15:19:42
General information
Forum:
Microsoft SQL Server
Category:
Security
Miscellaneous
Thread ID:
00323104
Message ID:
00323232
Views:
24
Ken,

Check out www.swynk.com. Somewhere overthere is a stored procedure that will do what you want. If, on the other hand, you're adventurious (sp?), you could easily write one. Scan sysusers for the people and sysobjects for the database objects and use dynamic SQL (the EXECUTE statement) within a loop.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform