spDelete_ObjectSecurity
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@Guid | uniqueidentifier | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spDelete_ObjectSecurity]
(
@Guid as uniqueidentifier
)
AS
BEGIN TRANSACTION
delete from dbo.CMSEVERYONESECURITYPRIVS where SECUREDOBJECTGUID = @Guid
delete from dbo.CMSOBJETSECURITYEXCEPTION where SECUREDOBJECTGUID = @Guid
COMMIT TRANSACTION