---------------------------------------------------------------------------
--------------- CREAZIONE UTENTE METODO CON PASSWORD --------------------
---------------------------------------------------------------------------

IF NOT EXISTS(SELECT 1 FROM MASTER.DBO.SYSLOGINS WHERE LOGINNAME ='utente')
EXEC sp_addlogin N'utente', 'password'

EXEC sp_changedbowner 'sa', false
GO

EXEC sp_revokedbaccess N'utente'
EXEC sp_grantdbaccess N'utente', N'utente'
EXEC sp_addrolemember N'Metodo98', N'utente'
GO

