SQL & PL/SQL

Hi,

I have a table that stores database schema ids. I have to write a trigger that'll grants some privileges to newly added schema id. Is it possible.

I hv written following trigger . please help me--

create or replace trigger TRG_REVSUBSYS
after insert on REVSUBSYS for each row
begin
if :new.ID = :new.SCHEMAID then
grant insert, update on PARTNER to :new.SCHEMAID;
grant insert, update(DUEDATE,AMOUNT,STATUS,DETAILS) on BILLINGADVICE to :new.SCHEMAID;
grant insert, update, delete on BILLINGADVICELINEITEMS to :new.SCHEMAID;
grant insert, update(DUEDATE,AMOUNT,STATUS,DETAILS) on PAYMENTADVICE to :new.SCHEMAID;
grant insert, delete on PAYMENTADVICEBILLS to :new.SCHEMAID;
end if;
end;

Amitesh