Re: A question from a newbie

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 06:40:48 -0500

To add to Geoff's response, the built-in db_datareader and db_datawriter
roles are fine if these meet your security requirements. Granting
permissions to individual users or user-defined roles is appropriate when
you need more granular security and/or stored procedure execute permissions.
Utility scripts can be faster than granting permissions via Enterprise
Manager when you have a lot of objects. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"vvenk" <vvenk@discussions.microsoft.com> wrote in message 
news:2FB6F0F8-D8B8-47B0-8743-DD51C39D4A5E@microsoft.com...
> Geoff:
>
> Thanks a lot. I was reading some of the postings on this forum that
> suggested that I have to write a script to cycle through all the tables.
>
> Your's is the most elegant solution.
>
> Venkat
>
> "Geoff N. Hiten" wrote:
>
>> Add the user to the db_datareader fixed database role.
>>
>> -- 
>> Geoff N. Hiten
>> Microsoft SQL Server MVP
>> Senior Database Administrator
>> Careerbuilder.com
>>
>> I support the Professional Association for SQL Server
>> www.sqlpass.org
>>
>> "vvenk" <vvenk@discussions.microsoft.com> wrote in message
>> news:A63A543C-1176-4AEF-BC2E-2FBA35D5DB63@microsoft.com...
>> > Can somebody tell me the correct syntax if I want to grant SELECT
>> privileges
>> > on all tables in a db?
>> >
>> > I tried:
>> >
>> > GRANT SELECT TO public;
>> >
>> > Thanks.
>> >
>> > Venkat
>>
>>
>>

Relevant Pages

  • Re: Share calendars with group permissions help?...
    ... I have created security groups in Active Directory and put the members ... Yet adding the group to "Share My Calendar" ... with group permissions not individual permissions. ... NOT individual users. ...
    (microsoft.public.exchange.admin)
  • Team Site Permissions using Email Groups
    ... Security Groups) to assign permissions to SPS2003 Team Sites. ... the group is "broken out" into individual users when proceeding ... In many cases - we WANT the group to remain "as a group" when assigning ...
    (microsoft.public.sharepoint.portalserver)
  • RE: asp.net and IIS 6, access denied to the web directory.
    ... Have you tried granting read/execute permissions to the Users or Everyone ... Account was still named after the name of the base machine, ... > granting access rights to the resource to the ASP.NET request identity. ...
    (microsoft.public.inetserver.iis.security)
  • Cant get groups to work
    ... I have an Access ADP on SQL2000, uaing Windows users and groups.. ... Individual users with granted permissions work OK. ... if I drop the individual users and try to uses the Windows ...
    (microsoft.public.sqlserver.security)
  • Re: password
    ... the cumbersome method of password protection for individual ... of explicitly assigning file/folder permissions to individual users ... HOW TO Set, View, Change, or Remove File and Folder Permissions ...
    (microsoft.public.windowsxp.basics)