Home All Groups Group Topic Archive Search About

StoredProc View Permission

Author
11 Jan 2006 8:05 PM
icsTeam
Hi there,

We would like to create a restricted account in such a way that that account
cannot view all stored procs from Query Analyzer or Enterprise Manage. We
want to give view access to some stored procs though.

Currently I can restrict this account so that user won't be able to view any
of the stored procs but I want this account to have view rights to some
stored procs.

Is this possible? Please help!

Thanks,
icsTeam

Author
11 Jan 2006 8:10 PM
Andrew J. Kelly
Not in SQL2000 but it is in 2005.

--
Andrew J. Kelly  SQL MVP


Show quote
"icsTeam" <u17530@uwe> wrote in message news:5a36485498c56@uwe...
> Hi there,
>
> We would like to create a restricted account in such a way that that
> account
> cannot view all stored procs from Query Analyzer or Enterprise Manage. We
> want to give view access to some stored procs though.
>
> Currently I can restrict this account so that user won't be able to view
> any
> of the stored procs but I want this account to have view rights to some
> stored procs.
>
> Is this possible? Please help!
>
> Thanks,
> icsTeam

AddThis Social Bookmark Button