Re: Granting Permissions on Multiple Tables

From: Lyudmila Fokina [MSFT] (lyudmilf_at_online.microsoft.com)
Date: 06/22/04

  • Next message: Sue Hoegemeier: "Re: configuring antivirus" 
    Date: Tue, 22 Jun 2004 12:55:33 -0700

    Instead of creating a new role you can add these users/group to
    db_datareader fixed db role.
    Members of db_datareader fixed db role have select permissions on any
    objects in the db.

    Thanks,
    Lyudmila Fokina

    Please do not send e-mail directly to this alias. This alias is for
    newsgroup purposes only
    Disclaimer: This posting is provided "AS IS" with no warranties, and confers
    no rights.

    "Jon Jones" <Jon Jones@discussions.microsoft.com> wrote in message
    news:96F7208A-EA64-467A-8AD2-5477782ED32E@microsoft.com...
    > 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: Sue Hoegemeier: "Re: configuring antivirus"

    Relevant Pages

    • Re: Problem on quering Access link table
      ... Is "Alias" a field in the Exchange table? ... > simply test the recordset for BOF/EOF? ... > Access Database Samples: www.rogersaccesslibrary.com ... I wrote ASP code to use Alias ...
      (microsoft.public.access.queries)
    • Re: Select from open view using DBF()
      ... So you created an alias like this? ... At any rate as I mentioned I'm using a parameterized view in a database. ... will not see any un-saved changes as VFP appears to do a USE AGAIN and ... I have worked around it by using copy to array and other commands, ...
      (microsoft.public.fox.vfp.dbc)
    • Re: SCR and Replay Queue length
      ... Are you also able to get the file attributes for the seeding directory using attrib? ... This posting is provided "AS IS" with no warranties, ... Please do not send email directly to this alias. ... > permon when trying to seed the database and didn't see anything out of> the ...
      (microsoft.public.exchange.admin)
    • Re: Priv1.edb and stm size cannot reduce after eseutil /d
      ... it would mount with blank a database. ... Please do not send e-mail directly to this alias. ... it was four o'clock by the time I got the defrag copy on to ... > the drive, if I had mistype the name, would the services start again? ...
      (microsoft.public.exchange.admin)
    • Re: Serious errors with Create view command
      ... Either you open each view as needed with a different alias and assign this ... stored in the database, ... Edit Stored Procedures opens a code editing window and saves the code you ... can't paste it INTO the view designer sql view window as that's Read ...
      (microsoft.public.fox.helpwanted)