-----------------------------------------------------------------------------
-- DDL for Login 'q'
-----------------------------------------------------------------------------

print '<<<<< CREATING Login - "q" >>>>>'
go 

IF EXISTS (SELECT 1 FROM master.dbo.syslogins WHERE name = 'q')
	exec sp_droplogin 'q'


IF (@@error != 0)
BEGIN
	PRINT "Error CREATING Login 'q'"
	SELECT syb_quit()
END
go

exec  sp_addlogin  'q', 'password', @defdb='test', @deflanguage='us_english', @auth_mech = 'ANY'

exec  sp_locklogin  'q', 'unlock'



go 

-----------------------------------------------------------------------------
-- Dependent DDL for Object(s)
-----------------------------------------------------------------------------
sp_passwordpolicy 'set', 'min digits in password', 1
go
sp_passwordpolicy 'set', 'min upper char in password', 1
go
sp_passwordpolicy 'set', 'min lower char in password', 1
go