35 lines
1.4 KiB
Transact-SQL
35 lines
1.4 KiB
Transact-SQL
USE [Arizona]
|
|
|
|
BEGIN TRANSACTION
|
|
SET XACT_ABORT ON;
|
|
|
|
--dbRoleDevUsr
|
|
REVOKE SELECT ON [wkl].[DocumentSignature] TO [dbRoleDevUsr]
|
|
REVOKE UPDATE ON [wkl].[DocumentSignature] TO [dbRoleDevUsr]
|
|
EXEC [sys].[sp_addrolemember] @rolename = 'db_datawriter',
|
|
@membername = 'dbRoleDevUsr'
|
|
EXEC [sys].[sp_addrolemember] @rolename = 'db_datareader',
|
|
@membername = 'dbRoleDevUsr'
|
|
|
|
|
|
--dbRoleIttechUsr
|
|
REVOKE SELECT ON [wkl].[DocumentSignature] TO [dbRoleIttechUsr]
|
|
REVOKE UPDATE ON [wkl].[DocumentSignature] TO [dbRoleIttechUsr]
|
|
|
|
--dbRoleTPPos
|
|
REVOKE SELECT ON [wkl].[DocumentSignature] TO [dbRoleTPPos]
|
|
REVOKE INSERT ON [wkl].[DocumentSignature] TO [dbRoleTPPos]
|
|
REVOKE SELECT ON [dbo].[Bmc_application_default] TO [dbRoleTPPos]
|
|
REVOKE UPDATE ON [dbo].[Bmc_application_default] TO [dbRoleTPPos]
|
|
REVOKE SELECT ON [dbo].[Bmc_application_key] TO [dbRoleTPPos]
|
|
REVOKE UPDATE ON [dbo].[Bmc_application_key] TO [dbRoleTPPos]
|
|
REVOKE SELECT ON [dbo].[Bmc_application_default] TO [dbRoleTPPos]
|
|
REVOKE UPDATE ON [dbo].[Bmc_application_default] TO [dbRoleTPPos]
|
|
REVOKE SELECT ON [dbo].[IT_config_setting] TO [dbRoleTPPos]
|
|
REVOKE UPDATE ON [dbo].[IT_config_setting] TO [dbRoleTPPos]
|
|
REVOKE SELECT ON [dbo].[Organizational_unit] TO [dbRoleTPPos]
|
|
REVOKE UPDATE ON [dbo].[Organizational_unit] TO [dbRoleTPPos]
|
|
|
|
--ROLLBACK TRANSACTION
|
|
COMMIT TRANSACTION
|