Answer:
Proper Authentication is required. Not all the people should get all the data. If this is the case then you are definitely going to find that data protection is breached. We need to define each user's role as well as privileges clearly or else we are definitely going to suffer. Always ensure proper authentication.
Explanation:
We need to define each user's roles and privileges. And that can be done through Authentication and Authorization,
Answer:
Create or replace trigger at_advisor
after delete or insert or update on advisor
for each row
Begin
if inserting
then
insert into
log_maj_adv
values
(
user, :new.adv_code, sysdate, 'insert'
)
;
elsif deleting
then
insert into
log_maj_adv
values
(
user, :new.adv_code, sysdate, 'delete'
)
;
else
insert into
log_maj_adv
values
(
user, :new.adv_code, sysdate, 'update'
)
;
end if;
End;
Explanation:
as per above answer.
