Arthur Fuller
artful at rogers.com
Fri Mar 11 13:18:07 CST 2005
Re: my previous question and this subsequent one... LOL. Francisco Tapia wrote: >Joe, > I recommend you read the section in BOL (Books on line) re: Roles. >This will make it easy for you to add new users with the desired >permissions. > > > > > >On Mon, 7 Mar 2005 11:20:02 -0500, Joe Rojas <JRojas at tnco-inc.com> wrote: > > >>Hello, >> >>Is there a way to tell SQL Server 7 that a user has access to all stored >>procedures without have to open each SP and clicking on the permissions >>button? >>Also, it would be nice if a user automatically got the correct permissions >>to any new SP. >> >>Thanks, >> >>JR >> >>