CREATE TABLE [dbo].[ca_object_ace]
(
[object_def_uuid] [binary] (16) NOT NULL,
[security_profile_uuid] [binary] (16) NOT NULL,
[ace] [int] NOT NULL,
[access] [int] NOT NULL,
[security_level] [int] NOT NULL,
[object_type] [int] NOT NULL
) ON [PRIMARY]
GO
/* End of lines added to convert to online lock */

CREATE trigger rule_u_so_updated_object_ace
     on ca_object_ace
     after update
as
begin
  
   declare     @_level     integer;
   declare     @_object_uuid    binary(16);
   declare     @_sp_uuid    binary(16);
   declare     @_level_before    integer;
   declare     @_object_type     integer;
/*    
   select @_level         =  (select security_level from inserted);
   select @_object_uuid    = (select object_def_uuid from deleted);
   select @_sp_uuid    = (select security_profile_uuid from deleted);
   select @_level_before    = (select security_level from  deleted);
   select @_object_type     = (select object_type from deleted);    
--    execute  proc_u_so_updated_object_ace @_level, @_object_uuid, @_sp_uuid, @_level_before, @_object_type;

*/
    IF ( (SELECT trigger_nestlevel( object_ID('rule_u_so_updated_object_ace') ) ) < 2 )
    begin

        declare c_oace_upd cursor local
        for select i.security_level, i.object_def_uuid, d.security_profile_uuid, d.security_level, d.object_type
        from inserted as i, deleted as d
        where i.security_profile_uuid = d.security_profile_uuid
                        and i.object_def_uuid = d.object_def_uuid ;/* itrac 12093*/
    --                    and i.object_type = d.object_type;
     
       
        open c_oace_upd
        fetch from c_oace_upd into @_level, @_object_uuid, @_sp_uuid, @_level_before,@_object_type --get first row
        
        while @@fetch_status = 0
        begin
       
        execute  proc_u_so_updated_object_ace @_level, @_object_uuid, @_sp_uuid, @_level_before, @_object_type;
            fetch from c_oace_upd into @_level, @_object_uuid, @_sp_uuid, @_level_before,@_object_type  --get next row
        
        end
        close c_oace_upd;
        deallocate c_oace_upd;
    end

end
GO
ALTER TABLE [dbo].[ca_object_ace] ADD CONSTRAINT [XPKca_object_ace] PRIMARY KEY CLUSTERED ([object_def_uuid], [security_profile_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ca_object_ace_x1] ON [dbo].[ca_object_ace] ([object_def_uuid], [security_profile_uuid], [ace]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ca_object_ace_x0] ON [dbo].[ca_object_ace] ([object_type]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ca_object_ace] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_object_ace] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_object_ace] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_object_ace] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_object_ace] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_object_ace] TO [dms_backup_group]
GRANT INSERT ON  [dbo].[ca_object_ace] TO [dms_backup_group]
GRANT DELETE ON  [dbo].[ca_object_ace] TO [dms_backup_group]
GRANT UPDATE ON  [dbo].[ca_object_ace] TO [dms_backup_group]
GRANT SELECT ON  [dbo].[ca_object_ace] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_object_ace] TO [upmuser_group]
GO