==== MS SQLServer samples ====

=== Create a login in MS SQL Server ===
<code sql 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
</code>

<code sql create_db_user.sql>
USE [niota_MY_STAGE]
GO

CREATE USER [niota_web] FOR LOGIN [niota_web] WITH DEFAULT_SCHEMA=[dbo]
GO

</code>


<code sql 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
</code>


==== MySQL samples ====

<code sql 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;
</code>


<code sql 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;

</code>