|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
StoredProc View PermissionHi 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 Not in SQL2000 but it is in 2005.
-- Show quoteAndrew J. Kelly SQL MVP "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 |
|||||||||||||||||||||||