Hi guys,I'm trying to create a database install script which has exclusive rights to the user it creates, and denies access to windows authentication:Create Database DB_NAME;GOUSE [DB_NAME]GOCREATE LOGIN [logDB_NAME] WITH PASSWORD='password', DEFAULT_DATABASE=[DB_NAME], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ONGOCREATE USER [usrDB_NAME] FOR LOGIN [logDB_NAME] WITH DEFAULT_SCHEMA=[db_owner]GOALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [usrDB_NAME]GOEXEC sp_addrolemember N'db_securityadmin', N'usrDB_NAME'GOEXEC sp_addrolemember N'db_owner', N'usrDB_NAME'GO...Create Tables...EXEC sp_changedbowner 'usrDB_NAME', False
I seem to have the opposite effect though, windows authentication is fine with full access but none to the logDB_NAME login...Thanks,Jesse