CREATE TABLE [dbo].[ca_security_class_def]
(
[class_def_uuid] [binary] (16) NOT NULL,
[class_type] [int] NOT NULL,
[class_id] [int] NOT NULL,
[creation_date] [int] NULL
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.rule_i_so_class_def    Script Date: 12/1/2005 11:51:06 PM ******/



/************************************************/
/*  trigger if a new class definition is added */

CREATE trigger rule_i_so_class_def
    on ca_security_class_def
    after insert
as
begin
  declare @_cd_uuid binary(16);
  declare @_classId integer;
    
  select @_cd_uuid = (select class_def_uuid from inserted);
  select @_classId = (select class_id from inserted);
        
  execute  proc_i_so_class_def @_cd_uuid, @_classId;
end;
GO
ALTER TABLE [dbo].[ca_security_class_def] ADD CONSTRAINT [XPKca_security_class_def] PRIMARY KEY CLUSTERED ([class_def_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IDX_sec_class_def_clsId] ON [dbo].[ca_security_class_def] ([class_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ca_security_class_def] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_security_class_def] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_security_class_def] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_security_class_def] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_security_class_def] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_security_class_def] TO [dms_backup_group]
GRANT INSERT ON  [dbo].[ca_security_class_def] TO [dms_backup_group]
GRANT DELETE ON  [dbo].[ca_security_class_def] TO [dms_backup_group]
GRANT UPDATE ON  [dbo].[ca_security_class_def] TO [dms_backup_group]
GRANT SELECT ON  [dbo].[ca_security_class_def] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_security_class_def] TO [upmuser_group]
GO