CREATE TABLE [dbo].[polidef]
(
[domainid] [int] NOT NULL,
[polid] [int] NOT NULL,
[polsev] [int] NULL,
[polname] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[polmemo] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[lrundate] [int] NULL,
[query_uuid] [binary] (16) NULL,
[eval_freq] [int] NULL,
[evaluation_uuid] [binary] (16) NULL,
[auto_rep_version] [timestamp] NULL,
[policy_uuid] [binary] (16) NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL,
[notify_user_uuid] [binary] (16) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Trigger dbo.rule_d_so_del_qbased_policy    Script Date: 12/1/2005 11:50:52 PM ******/


/*
*********************************************
trigger for deleteing a query base policy
*/
CREATE trigger rule_d_so_del_qbased_policy
on polidef
after delete
as
begin
    declare @ddis_hw_uuid  binary(16);

    DECLARE cur_d_so_del_qbased_policy CURSOR
        FOR select policy_uuid from deleted

    OPEN cur_d_so_del_qbased_policy
    FETCH NEXT FROM cur_d_so_del_qbased_policy INTO @ddis_hw_uuid
    WHILE @@FETCH_STATUS = 0
    BEGIN

        execute   proc_d_so_removed_object @ddis_hw_uuid
        FETCH NEXT FROM cur_d_so_del_qbased_policy INTO @ddis_hw_uuid;

    END

    CLOSE cur_d_so_del_qbased_policy
    DEALLOCATE cur_d_so_del_qbased_policy

end;
GO
/****** Object:  Trigger dbo.rule_i_so_new_qbased_policy    Script Date: 12/1/2005 11:51:47 PM ******/



/*
*********************************************************
*********************************************************
* Procedures and rules to manage policies
*********************************************************
*********************************************************
*/

/*
*********************************************
trigger for creating query based policy
*/
CREATE trigger rule_i_so_new_qbased_policy
     on polidef
     after insert
as
begin
    declare @_obj_uuid binary(16);
    declare @_clsid integer;
    declare @_uri nvarchar(255);

    select @_obj_uuid = (select policy_uuid from inserted);
    select @_clsid = 3300;
    select @_uri = (select creation_user from inserted);

    execute  proc_i_new_so_object @_obj_uuid, @_clsid, @_uri;
end;
GO
ALTER TABLE [dbo].[polidef] ADD CONSTRAINT [XPKpolidef] PRIMARY KEY CLUSTERED ([polid], [domainid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [polidef_idx_01] ON [dbo].[polidef] ([policy_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[polidef] TO [ams_group]
GRANT SELECT ON  [dbo].[polidef] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[polidef] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[polidef] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[polidef] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[polidef] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[polidef] TO [upmuser_group]
GO