how to give permission to users that users can
update/insert/delete on a row of table on timeing 10am to
6pm only?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
What is a trigger ?
11 Answers Accenture, BirlaSoft,
What does the file extension accdb stand for?
Can we use threading in pl/sql?
Are pl sql variables case sensitive?
Fetch an entire row from the employees table for a specific employee ID:
How do you run a query?
What is the difference between sql and t sql?
Maximum how many triggers can we use in trigger and How to find out how many records it fetched.
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
what is the difference between stored procedure and packaged procedure
find the third highest salary?
What are aggregate functions in sql?