Table of Contents

MS SQLServer samples

Create a login in MS SQL Server

create_login.sql
USE [master]
GO
 
CREATE LOGIN [niota_web] WITH PASSWORD=N'****', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
 
ALTER LOGIN [niota_web] ENABLE
GO
create_db_user.sql
USE [niota_MY_STAGE]
GO
 
CREATE USER [niota_web] FOR LOGIN [niota_web] WITH DEFAULT_SCHEMA=[dbo]
GO
alter_role_add.sql
USE [niota_MY_STAGE]
GO
 
ALTER ROLE [db_datareader] ADD MEMBER [niota_web];
 
ALTER ROLE [db_datawriter] ADD MEMBER [niota_web];
 
GO

MySQL samples

create_user.sql
-- Create admin user with a secure password
CREATE USER 'admin_niota'@'%' IDENTIFIED BY '*****';
 
-- Grant all privileges on schemas matching 'niota%'
GRANT ALL PRIVILEGES ON `niota%`.* TO 'admin_niota'@'%';
 
-- Grant SELECT privilege on the 'sys' schema
GRANT SELECT ON `sys`.* TO 'admin_niota'@'%';
 
-- to all this user also backup / restore
GRANT PROCESS ON *.* TO 'admin_niota'@'%';
 
GRANT SUPER ON *.* TO 'admin_niota'@'%';
FLUSH PRIVILEGES;
 
 
-- Apply changes
FLUSH PRIVILEGES;
create_db.sql
CREATE DATABASE IF NOT EXISTS niota_meta_c200 CHARACTER SET UTF8MB4 COLLATE UTF8MB4_general_ci;
USE niota_meta_c200 ;
SELECT DATABASE() AS schema_available;