Re: find out a user/account permission...

From: Steve Lin (lins_at_nospam.portptld.com)
Date: 04/22/04 

Date: Thu, 22 Apr 2004 08:08:14 -0700

can you resend the query w/o using attachement?
my company remove any email attachment from outside automatically. (or if
you can rename the file and change the file extension to .port and resend
it?)
thank you

"Mark Allison" <marka@no.tinned.meat.mvps.org> wrote in message
news:uR$LaZFKEHA.2784@TK2MSFTNGP10.phx.gbl...
> The attached query should work for you, it is based around sysprotects.
>
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
>
>
>
>
> "Steve Lin" <lins@nospam.portptld.com> wrote in message
> news:edcL0R$JEHA.428@TK2MSFTNGP11.phx.gbl...
> > is there an easy to find out an user/account's permsions within a
> database?
> > thank you
> > a list of objects and rights.
> > such as
> >
> > select delete insert exec
> > table1 x x
> > table2 x
> > stored proc x
> >
> >
>
>
>

Loading