home *** CD-ROM | disk | FTP | other *** search
/ Computer Shopper 132 / dpcs0299.iso / Business / 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}