CREATE TABLE [dbo].[ca_security_profile]
(
[security_profile_uuid] [binary] (16) NOT NULL,
[name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uri] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[buildin_profile] [int] NULL CONSTRAINT [DF__ca_securi__build__0EE3280B] DEFAULT ((0)),
[type] [int] NULL,
[default_ace] [int] NULL,
[area_ace] [int] NULL CONSTRAINT [DF__ca_securi__area___53EEE174] DEFAULT ((-1)),
[area_enabled] [int] NULL CONSTRAINT [DF__ca_securi__area___54E305AD] DEFAULT ((0))
) ON [PRIMARY]
GO
/****** Object:  Trigger dbo.rule_d_so_removed_security_prof    Script Date: 12/1/2005 11:51:36 PM ******/
CREATE trigger rule_d_so_removed_security_prof
on ca_security_profile
instead of delete
as
begin

    declare @old_object_uuid as binary(16);
    declare cur_cl cursor for
        select security_profile_uuid from deleted;

    open cur_cl;
    fetch cur_cl into @old_object_uuid; -- get first
    while @@fetch_status = 0
    begin
    
         execute  proc_d_so_removed_security_prof @old_object_uuid ;
        delete from ca_security_profile where security_profile_uuid = @old_object_uuid;
        fetch cur_cl into @old_object_uuid;

     end; -- while
     close cur_cl;
     deallocate cur_cl;

end;
GO
/*
***********************************************
rule for insert a new security profile
*/
CREATE trigger rule_i_new_so_security_profile
    on ca_security_profile
    after insert
as
begin
    declare  @_obj_uuid binary(16);
    declare  @_type integer;
    declare  @_default_ace    integer;
    declare  @_default_area    integer;
    declare  @_area_enabled    integer;

    set nocount on;
    select @_obj_uuid = (select security_profile_uuid from inserted);
    select @_type     = (select type from inserted);
    select @_default_ace    = (select default_ace from inserted);
    select @_default_area    = (select area_ace from inserted);
    select @_area_enabled    = (select area_enabled from inserted);

    execute  proc_i_new_so_security_profile  @_obj_uuid,  @_type,  @_default_ace;

end;
GO
ALTER TABLE [dbo].[ca_security_profile] ADD CONSTRAINT [XPKca_security_profile] PRIMARY KEY CLUSTERED ([security_profile_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [x1ca_security_profile] ON [dbo].[ca_security_profile] ([name], [type]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ca_security_profile] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ca_security_profile] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ca_security_profile] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ca_security_profile] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_security_profile] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ca_security_profile] TO [dms_backup_group]
GRANT INSERT ON  [dbo].[ca_security_profile] TO [dms_backup_group]
GRANT DELETE ON  [dbo].[ca_security_profile] TO [dms_backup_group]
GRANT UPDATE ON  [dbo].[ca_security_profile] TO [dms_backup_group]
GRANT SELECT ON  [dbo].[ca_security_profile] TO [regadmin]
GRANT SELECT ON  [dbo].[ca_security_profile] TO [upmuser_group]
GO