Projekt

Všeobecné

Profil

Stiahnuť (727 Bytes)

PridanieDomenovehoKontaDoPrevisu » 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
    (1-1/1)