[dba-SQLServer] Setting permissions in SQL Server 7

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
-- 
-Francisco
http://pcthis.blogspot.com | PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...