Create SQL 2000 Database Login and User By a script

/****** Add Login [Newuserid]    ******/

EXEC master.dbo.sp_addlogin @loginame = N'Newuserid', @passwd = 'Newuserid', @defdb = N'master', @deflanguage = N'us_english'

 

USE [DBname]

GO

/****** Grant User [Newuserid]     ******/

 

EXEC dbo.sp_grantdbaccess @loginame = N'Newuserid', @name_in_db = N'Newuserid'

 

USE [DBname]

GO

/******Add DatabaseRole [db_NewuseridRole]    ******/

EXEC dbo.sp_addrole @rolename = N'db_NewuseridRole', @ownername = N'dbo'

Exec sp_addrolemember  @rolename =  'db_NewuseridRole' ,

     @membername = 'Newuserid'

 

/****** Grant Permissions [db_NewuseridRole]    ******/

GRANT EXECUTE ON [dbo].PurgeAPLExtract TO [db_NewuseridRole]