home *** CD-ROM | disk | FTP | other *** search
/ PC Pro 1999 January / dppcpro0199a.iso / January / Superoff / super / Sql / SOADMIN.YQL < prev    next >
Encoding:
Text File  |  1996-11-08  |  170 b   |  5 lines
  1. PARAMETERS userid password, database
  2.  
  3. exec sp_addlogin {userid}, {password}, {database}
  4. exec sp_adduser {userid}, {userid}, SOADMIN
  5. grant create procedure to {userid}