Re: A question from a newbie

From: vvenk (vvenk_at_discussions.microsoft.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 13:57:08 -0700

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: Connecting to an instance in a cluster
    ... "Geoff N. Hiten" wrote: ... you cannot reuse port numbers. ... Microsoft SQL Server MVP ... That is the port you have to open on the firewall. ...
    (microsoft.public.sqlserver.clustering)
  • Re: newbie help: failover server
    ... Geoff, after doing some reading it appears that log shipping is only ... We are running Standard Edition. ... > I support the Professional Association for SQL Server ... >> As far as business decision vs technology decision, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Passive node starting the SQL Server services - services set t
    ... "Geoff N. Hiten" wrote: ... Preferred owners list IS sorted by most preferred owner first. ... lost the IP ADDRESS resource long enough to start a failover or restart ... drive not being available - the server name is the SQL Server Network ...
    (microsoft.public.sqlserver.clustering)
  • Re: Voice Command from MS in Ipaq 6315
    ... I support the Professional Association for SQL Server ... "Geoff N. Hiten" wrote in message ... > Microsoft SQL Server MVP (NOT Pocket PC. ... >> When I am using the headset and I use voice command ...
    (microsoft.public.pocketpc.phone_edition)
  • Re: Physical/Vertial node cluster memory setup?
    ... I fully agree with Geoff, however as you are commited to see this thru... ... VMWare supports physical/virtual clustering, ... bit SQL Server you should set the max memory. ...
    (microsoft.public.sqlserver.clustering)