CREATE procedure ols_ac_reset
as
begin
-- setup security profiles
--
update ca_security_profile set area_ace = s.set_val_lng from ca_settings s
    where  s.set_id = 900;

update ca_security_profile set area_enabled = s.set_val_lng from ca_settings s
    where s.set_id = 901;


-- setup the ols_area_ace table
insert into ols_area_ace ( object_def_uuid, object_type )
        select distinct object_def_uuid, object_type
            from ca_object_ace ;
            
update ols_area_ace set area_ace = s.set_val_lng from ca_settings s
    where  s.set_id = 900;

end
GO
GRANT EXECUTE ON  [dbo].[ols_ac_reset] TO [ca_itrm_group]
GO