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 |
Write the command to remove all players named sachin from the players table.
What do we need to check in database testing?
how to delete an existing column in a table? : Sql dba
How to create an array in pl/sql?
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is set serveroutput on?
List out the acid properties and explain?
What is the difference between count 1 and count (*) in a sql query?
what is blob? : Sql dba
What is a unique key and primary key and foreign key?
How does a trigger work?