Granting Permissions on Multiple Tables

From: Jon Jones (Jones_at_discussions.microsoft.com)
Date: 06/22/04

  • Next message: Lyudmila Fokina [MSFT]: "Re: Granting Permissions on Multiple Tables" 
    Date: Tue, 22 Jun 2004 12:13:02 -0700

    I created a new Role called GRPSELECT. I want to give this group the ability to only run the SELECT statement on all the tables in my database. Right now I can run "GRANT SELECT ON table TO GRPSELECT" in Query Analyzer, but it only allows me to do this to one table at a time.

    How can I accomplish this to all 600 tables in the database without manually typing in every single table?

    Thanks in advance!

  • Next message: Lyudmila Fokina [MSFT]: "Re: Granting Permissions on Multiple Tables"