11. Описание джоба резервного копирования данных

exec msdb.dbo.sp_add_job @job_name = 'BACKUP',

@enabled = 1,

@description = 'BACKUP',

@owner_login_name = 'sa',

@notify_level_eventlog = 1

go

EXEC msdb.dbo.sp_add_jobstep @job_name = 'BACKUP',

@step_name = 'BACKUPDATABASE',

@subsystem = 'TSQL',

@command = ' BACKUP DATABASE db412 TO DISK = ''E:\Институт\ВМКСС\4 курс\Базы данных\Курсовая\db410BACKUP.bak'' ',

@on_success_action = 1,

@database_name = 'db410',

@retry_attempts = 3,

@retry_interval = 0

go

EXEC msdb.dbo.sp_add_jobschedule @job_name = 'BACKUP',

@name = 'ScheduledBACKUP',

@freq_type = 4,

@freq_interval = 1,

@active_start_time = '000000'

EXEC msdb.dbo.sp_add_jobserver @job_name = 'BACKUP', @server_name = N'(local)'

EXEC msdb.dbo.sp_start_job 'BACKUP';

12. Описание создания ролей, прав и пользователей

--Создание ролей

create role manager_supply

create role manager_delivery

create role director

create role administrator

--Удаление ролей

drop role manager_supply

drop role manager_delivery

drop role director

drop role administrator

--Права ролей

grant execute on object::dbo.View_good to manager_supply

grant execute on object::dbo.Add_good to manager_supply

grant execute on object::dbo.Update_qunt_good to manager_supply

grant execute on object::dbo.Add_supplier to manager_supply

grant execute on object::dbo.Del_supplier to manager_supply

grant execute on object::dbo.View_supplier to manager_supply

grant execute on object::dbo.View_good to manager_delivery

grant execute on object::dbo.Del_good to manager_delivery

grant execute on object::dbo.Update_qunt_good to manager_delivery

grant execute on object::dbo.Add_client to manager_delivery

grant execute on object::dbo.Del_client to manager_delivery

grant execute on object::dbo.View_client to manager_delivery

grant execute on object::dbo.View_table to director

grant execute on object::dbo.View_ed_izm to director

grant execute on object::dbo.View_group to director

grant execute on object::dbo.View_good to director

grant execute on object::dbo.View_client to director

grant execute on object::dbo.View_supplier to director

grant execute on object::dbo.View_delivery to director

grant execute on object::dbo.View_cons_note to director

grant execute on object::dbo.View_shipment to director

grant execute on object::dbo.View_zakaz to director

grant execute on object::dbo.View_hist_cost to director

grant execute on object::dbo.View_table to administrator

grant execute on object::dbo.View_ed_izm to administrator

grant execute on object::dbo.View_group to administrator

grant execute on object::dbo.View_good to administrator

grant execute on object::dbo.View_client to administrator

grant execute on object::dbo.View_supplier to administrator

grant execute on object::dbo.View_delivery to administrator

grant execute on object::dbo.View_cons_note to administrator

grant execute on object::dbo.View_shipment to administrator

grant execute on object::dbo.View_zakaz to administrator

grant execute on object::dbo.View_hist_cost to administrator

grant execute on object::dbo.Add_ed_izm to administrator

grant execute on object::dbo.Add_group to administrator

grant execute on object::dbo.Add_good to administrator

grant execute on object::dbo.Add_client to administrator

grant execute on object::dbo.Add_supplier to administrator

grant execute on object::dbo.Add_delivery to administrator

grant execute on object::dbo.Add_cons_note to administrator

grant execute on object::dbo.Add_shipment to administrator

grant execute on object::dbo.Add_zakaz to administrator

grant execute on object::dbo.Add_hist_cost to administrator

grant execute on object::dbo.Del_ed_izm to administrator

grant execute on object::dbo.Del_group to administrator

grant execute on object::dbo.Del_good to administrator

grant execute on object::dbo.Del_client to administrator

grant execute on object::dbo.Del_supplier to administrator

grant execute on object::dbo.Del_delivery to administrator

grant execute on object::dbo.Del_cons_note to administrator

grant execute on object::dbo.Del_shipment to administrator

grant execute on object::dbo.Del_zakaz to administrator

grant execute on object::dbo.Del_hist_cost to administrator

grant execute on object::dbo.Update_qunt_good to administrator

--Создание логинов для пользователей и пользователей

create login [Иванов] with password='1111', default_database=[db410]

create user [Иванов] for login [Иванов]

create login [Петров] with password='2222', default_database=[db410]

create user [Петров] for login [Петров]

create login [Сидоров] with password='3333', default_database=[db410]

create user [Сидоров] for login [Сидоров]

create login [Васечкин] with password='4444', default_database=[db410]

create user [Васечкин] for login [Васечкин]

create login [rrr] with password='123', default_database=[db410]

create user [rrr] for login [rrr]

--Назначение ролей пользователям

exec sp_addrolemember 'manager_supply', 'Иванов'

exec sp_addrolemember 'manager_delivery', 'Петров'

exec sp_addrolemember 'director', 'Сидоров'

exec sp_addrolemember 'administrator', 'Васечкин'

exec sp_addrolemember 'manager_supply', 'rrr'