CREATE TABLE [dbo].[ca_class_ace]
(
[ace] [int] NOT NULL,
[class_def_uuid] [binary] (16) NOT NULL,
[security_profile_uuid] [binary] (16) NOT NULL,
[access] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.rule_u_so_class_ace    Script Date: 12/1/2005 11:50:56 PM ******/



/************************************************/
/*  trigger if class ace is updated */

CREATE trigger [dbo].[rule_u_so_class_ace]
on [dbo].[ca_class_ace]
after update
as                                        
begin                                  

   declare @new_ace     integer;
   declare @new_access        integer;
   declare @old_ace         integer;
   declare @sp_uuid         binary(16);
   declare @class_uuid        binary(16);

/*
   select @new_ace     = (select ace from inserted);                             
   select @new_access    = (select access from inserted);                        
   select @old_ace     = (select ace from deleted);                              
   select @sp_uuid     = (select security_profile_uuid from inserted);           
   select @class_uuid    = (select class_def_uuid from inserted);                
                                                                      
   execute  proc_u_so_class_ace @new_ace, @new_access, @old_ace , @sp_uuid , @class_uuid;
*/


-- Create a class ACE for this class
    declare c_ins cursor local
       for select i.ace, i.access, i.security_profile_uuid, i.class_def_uuid, d.ace
    from inserted as i, deleted as d
    where i.security_profile_uuid = d.security_profile_uuid and i.class_def_uuid = d.class_def_uuid ;
                                 /* itrac 12093*/

   
    open c_ins
    fetch from c_ins into @new_ace, @new_access, @sp_uuid, @class_uuid, @old_ace --get first row
    
    while @@fetch_status = 0
    begin
   
      execute  proc_u_so_class_ace @new_ace, @new_access, @old_ace , @sp_uuid , @class_uuid;
      fetch from c_ins into @new_ace, @new_access, @sp_uuid, @class_uuid, @old_ace --get next row
    
    end
    close c_ins;
    deallocate c_ins;

end;
GO
ALTER TABLE [dbo].[ca_class_ace] ADD CONSTRAINT [XPKca_class_ace] PRIMARY KEY CLUSTERED ([security_profile_uuid], [class_def_uuid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ca_class_ace] ADD CONSTRAINT [$ca_cl_r0000086e00000000] FOREIGN KEY ([class_def_uuid]) REFERENCES [dbo].[ca_security_class_def] ([class_def_uuid])
GO
ALTER TABLE [dbo].[ca_class_ace] ADD CONSTRAINT [$ca_cl_r0000087800000000] FOREIGN KEY ([security_profile_uuid]) REFERENCES [dbo].[ca_security_profile] ([security_profile_uuid])
GO
GRANT SELECT ON  [dbo].[ca_class_ace] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_class_ace] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_class_ace] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_class_ace] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_class_ace] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_class_ace] TO [dms_backup_group]
GRANT INSERT ON  [dbo].[ca_class_ace] TO [dms_backup_group]
GRANT DELETE ON  [dbo].[ca_class_ace] TO [dms_backup_group]
GRANT UPDATE ON  [dbo].[ca_class_ace] TO [dms_backup_group]
GRANT SELECT ON  [dbo].[ca_class_ace] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_class_ace] TO [upmuser_group]
GO