issue-logger

create_user.sql
View Options

			-- Create a SQL user for query history
			--grant all privileges on shrine_query_history.* to SHRINE_MYSQL_USER@SHRINE_MYSQL_HOST identified by 'SHRINE_MYSQL_PASSWORD';

			-- Hibernate will create the schema for us
			--drop existing login if it exists
			IF EXISTS (SELECT name FROM master.sys.server_principals WHERE name = 'SHRINE_DB_USER')
			BEGIN
			DROP LOGIN [SHRINE_DB_USER];
			END



			IF EXISTS (SELECT name FROM master.sys.syslogins WHERE name = 'SHRINE_DB_USER')
			BEGIN
			DROP USER [SHRINE_DB_USER];
			END



			--create sql account
			CREATE LOGIN [SHRINE_DB_USER]
			WITH PASSWORD=N'SHRINE_DB_PASSWORD',
			DEFAULT_DATABASE=[SHRINE_DB_NAME],
			CHECK_EXPIRATION=OFF,
			CHECK_POLICY=OFF;


			USE [SHRINE_DB_NAME];


			--create user for the database
			CREATE USER [SHRINE_DB_USER]
			FOR LOGIN [SHRINE_DB_USER]
			WITH DEFAULT_SCHEMA=[SHRINE_DB_SCHEMA];



			--add user to the db_owner role for the database
			EXEC sp_addrolemember 'db_owner', 'SHRINE_DB_USER';