how to give permission to users that users can update/insert/delete on a row o

how to give permission to users that users can
update/insert/delete on a row of table on timeing 10am to
6pm only?

Question Posted / akshya

4 Answers
10606 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to give permission to users that users can update/insert/delete on a row of table on timeing 1..

Answer / kart

create or replace trigger trig_aone
before insert or update or delete on aone
for each row
begin
if to_char(sysdate,'HH24') not between (9) and (18) then
raise_application_error('-20011','u cant update in business
time');
end if;
end;

Is This Answer Correct ?

11 Yes

0 No

how to give permission to users that users can update/insert/delete on a row of table on timeing 1..

Answer / hari

We have to create trigger

create trigger trg_name
before insert/delete/update on table
when sysdate between 10am to 6pm
begin
logic
end;

Is This Answer Correct ?

13 Yes

3 No

how to give permission to users that users can update/insert/delete on a row of table on timeing 1..

Answer / pariksheet de

Grant Insert,Update,Delete
On Employees
To All

-----------------------------------------------

Create Trigger Upd_Employees
Before Insert,Update,Delete on Employees
For Each Row
Begin
if to_char(sysdate,'Dy') in
('Mon','Tues','Wed','Thrs','Fri','Sat','Sun') and to_char
(sysdate,'hr:mi') not between ('10:00') and ('6:00')
then raise_application_error(-
20145,'Insertion/Updation/Deletion can take place between
10:00 am and 6:00);
end if;
end;

Is This Answer Correct ?

1 Yes

0 No

how to give permission to users that users can update/insert/delete on a row of table on timeing 1..

Answer / cm

create one user in your windows o/s. Add this user into
your sql user in security.
This windows user provide the permission only 10am to 6pm.

Is This Answer Correct ?

0 Yes

9 No

Post New Answer