spClone_RoleObjectPrivs

            CREATE PROCEDURE [dbo].[spClone_RoleObjectPrivs]
            (
                @OldGuid AS uniqueidentifier,
                @NewGuid AS uniqueidentifier
            )

            AS
                    declare @CURRENTDATE datetime = getdate()
                    declare @CHANGEAGENTID uniqueidentifier
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                    INSERT INTO CMSEVERYONESECURITYPRIVS(
                        SECUREDOBJECTGUID,
                        SECUREDOBJECTTYPEID,
                        OBJECTTASKID,
                        VALUE,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                        )
                    SELECT
                        @NewGuid,
                        SECUREDOBJECTTYPEID,
                        OBJECTTASKID,
                        VALUE,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                    FROM CMSEVERYONESECURITYPRIVS
                        WHERE SECUREDOBJECTGUID = @OldGuid

                    INSERT INTO CMSOBJETSECURITYEXCEPTION(
                        SECUREDOBJECTGUID,
                        EXCEPTIONOBJECTGUID,
                        OBJECTTASKID,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                        )
                    SELECT
                        @NewGuid,
                        EXCEPTIONOBJECTGUID,
                        OBJECTTASKID,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                    FROM CMSOBJETSECURITYEXCEPTION
                        WHERE SECUREDOBJECTGUID = @OldGuid