add uer to DB

access.sql

EXEC sp_addrolemember db_datawriter,[[email protected]]
EXEC sp_addrolemember db_datareader,[[email protected]]
GRANT EXECUTE on SCHEMA :: etl to [[email protected]]
GRANT EXECUTE on DATABASE :: edpdevdb to [[email protected]]
GRANT EXECUTE on SCHEMA :: "external" to [[email protected]]
GRANT EXECUTE on SCHEMA :: staging to [[email protected]]
GRANT CREATE PROCEDURE on DATABASE :: edpdevdb to [[email protected]]
GRANT CREATE TABLE on DATABASE :: edpdevdb to [[email protected]]
GRANT ALTER ANY EXTERNAL FILE FORMAT to [[email protected]]
GRANT ALTER ANY EXTERNAL DATA SOURCE to [[email protected]]
GRANT ALTER on SCHEMA :: "external" to [[email protected]]
GRANT ALTER on SCHEMA :: staging to [[email protected]]
GRANT ALTER on SCHEMA :: etl to [[email protected]]