NoveDomenoveKonto.sql

Černý Martin, 14.08.2017 16:08

       USE [master]
       GO
       CREATE LOGIN [Domainame\Username] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
       GO
       USE [Databasename]
       GO
       CREATE USER [Domainame\Username] FOR LOGIN [Domainame\Username]
       GO
       ALTER ROLE [db_datareader] ADD MEMBER [Domainame\Username]
       GO
       ALTER ROLE [db_datawriter] ADD MEMBER [Domainame\Username]
       GO
       GRANT DELETE TO [Domainame\Username]
       GO
       GRANT EXECUTE TO [Domainame\Username]
       GO
       GRANT INSERT TO [Domainame\Username]
       GO
       GRANT REFERENCES TO [Domainame\Username]
       GO
       GRANT SELECT TO [Domainame\Username]
       GO
       GRANT SHOWPLAN TO [Domainame\Username]
       GO
       GRANT UPDATE TO [Domainame\Username]
       GO
       GRANT VIEW DATABASE STATE TO [Domainame\Username]
       GO
       GRANT VIEW DEFINITION TO [Domainame\Username]
       GO

Previs