Aanmaken database user/managed identity (volledige lijst)

-- SQL USER VOOR KLANT MET RESTRICTIES
CREATE USER aagbi_klant WITH PASSWORD = 'zm]vU!Cc<DBaUtJA';
GRANT SELECT ON SCHEMA :: [rep] TO aagbi_klant;
GRANT SELECT ON SCHEMA :: [rep_crs] TO aagbi_klant;
GRANT SELECT ON SCHEMA :: [pbi] TO aagbi_klant;
GRANT SELECT ON SCHEMA :: [aut] TO aagbi_klant;
 
-- MANAGED IDENTITY
CREATE USER [adf-aagbigen-p01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-p01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-p01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-p01];
GRANT EXECUTE TO [adf-aagbigen-p01];
 
-- SQL ONSDB USER ZONDER RESTRICTIES
CREATE USER aagbi_onsdb_klant WITH PASSWORD = '_WP_-@z[A<6e)55A';
ALTER ROLE db_datareader ADD MEMBER aagbi_onsdb_klant;
ALTER ROLE db_datawriter ADD MEMBER aagbi_onsdb_klant;
ALTER ROLE db_ddladmin ADD MEMBER aagbi_onsdb_klant;
GRANT EXECUTE TO aagbi_onsdb_klant;
 
-- MANAGED IDENTITY GEN
CREATE USER [adf-aagbigen-p01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-p01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-p01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-p01];
CREATE USER [adf-aagbigen-p02] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-p02];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-p02];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-p02];
CREATE USER [adf-aagbigen-s01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-s01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-s01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-s01];
CREATE USER [adf-aagbimgt-p01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbimgt-p01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbimgt-p01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbimgt-p01];
 
 
-- MANAGED IDENTITY CUS
CREATE USER [adf-aagbicus-p01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbicus-p01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbicus-p01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbicus-p01];
CREATE USER [adf-aagbigen-p02] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-p02];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-p02];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-p02];
CREATE USER [adf-aagbigen-s01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-s01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-s01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-s01];
CREATE USER [adf-aagbimgt-p01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbimgt-p01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbimgt-p01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbimgt-p01];
 
-- MANAGED IDENTITY STO
CREATE USER [adf-aagbigen-d01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-d01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-d01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-d01];
CREATE USER [adf-aagbigen-d02] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-d02];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-d02];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-d02];
CREATE USER [adf-aagbigen-a01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-a01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-a01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-a01];
CREATE USER [adf-aagbigen-a02] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-a02];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-a02];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-a02];
CREATE USER [adf-aagbigen-p01] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-p01];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-p01];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-p01];
CREATE USER [adf-aagbigen-p02] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE db_datareader ADD MEMBER [adf-aagbigen-p02];
ALTER ROLE db_datawriter ADD MEMBER [adf-aagbigen-p02];
ALTER ROLE db_ddladmin ADD MEMBER [adf-aagbigen-p02];
 
-- SQL USER ZONDER RESTRICTIES
CREATE USER aagbi_klant WITH PASSWORD = 'wm2[>E-@q^aZm$-T';
ALTER ROLE db_datareader ADD MEMBER aagbi_klant;
ALTER ROLE db_datawriter ADD MEMBER aagbi_klant;
ALTER ROLE db_ddladmin ADD MEMBER aagbi_klant;
GRANT EXECUTE TO aagbi_klant;
 
-- SQL USER WACHTWOORD AANPASSEN
ALTER USER aagbi_klant WITH PASSWORD = '_WP_-@z[A<6e)55A';