We have to create trigger create trigger trg

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 / hari

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is a boolean in sql?

981

What is sql stand for?

986

What is audit logout in sql profiler?

1024

Can we perform dml on view?

1044

Is a table valued function object?

1018

How can you view the errors encountered in a trigger?

962

What are different types of tables in sql?

998

What does 0 mean in sql?

965

Does sql backup shrink transaction log?

979

What is a unique key?

1055

What is pl sql package?

1032

what are dynamic queries in t-sql? : Transact sql

1021

when is the use of update_statistics command? : Sql dba

1049

how to run 'mysql' commands from a batch file? : Sql dba

1120

What is difference between pl and sql?

1059