Лабораторная работа 7

USE University
EXEC sp_addrole 'DEKAN'
GO

USE University
EXEC sp_addrole 'STUDENT'
GO

USE University
CREATE TABLE Discuplnu (
Kod_Discuplnu INT NOT NULL,
name_Discuplnu NCHAR(30) NULL,
kol_Discuplnu INT NULL,
CONSTRAINT PK_Dis PRIMARY KEY (Kod_Discuplnu));
GO

GRANT DELETE, INSERT, UPDATE, SELECT ON Discuplnu
TO DEKAN
GRANT EXECUTE TO DEKAN
GRANT SELECT ON Discuplnu TO STUDENT

EXEC sp_addlogin 'Ivanov_Dek', 'Ivanov', 'University'
USE University
EXEC sp_adduser 'Ivanov_Dek', 'Ivanov_Dek'
EXEC sp_addrolemember 'DEKAN', 'Ivanov_Dek'

EXEC sp_addlogin 'Petrov_Stud', 'Petrov', 'University'
USE University
EXEC sp_adduser 'Petrov_Stud', 'Petrov_Stud'
EXEC sp_addrolemember 'STUDENT', 'Petrov_Stud'