thank you .. ;) it works .. :)

----- Original Message -----
From: "David Cameron" <dcameron@i...>
To: "sql language" <sql_language@p...>
Sent: Monday, December 16, 2002 02:32 PM
Subject: [sql_language] RE: GRANT to all tables with sql statement


> run the following statement in Query analyser:
>
> DECLARE @User VarChar(100), @Permissions VarChar(100)
> SELECT @User = '<insert user name here>', @Permissions = '<insert
permission here>'
> -- the permission could be UPDATE, INSERT etc...
>
>
> SELECT 'GRANT ' + @Permissions + ' ON ' + name + ' TO ' + @User
> FROM sysobjects
> WHERE type = 'u'
>
> copy and paste the text into the execution window and execute it.
>
> regards
> David Cameron
> nOw.b2b
> dcameron@i...
>
> > -----Original Message-----
> > From: Siew Lien [mailto:sl.chin@f...]
> > Sent: Monday, 16 December 2002 5:39 PM
> > To: sql language
> > Subject: [sql_language] GRANT to all tables with sql statement
> >
> >
> > Hi,
> >
> > I am using MS SQL 2000, do you know any of the sql command
> > that can grant permission of a users to all objects (tables)
> > ? Currently, i need to manually check on the check box in for
> > each of the object and each of the update/insert/select/deletion ...
> >
> >
> > thank you.
> >
> >
> > regards,
> >
> >
> >
> >
>
>