Was this helpful?
DEFINE PERMIT Example
In the following example, define permit is used to enable "ariane" to retrieve names, ages, and salaries of employees whom she manages from the "employee" table at terminal "tta2" between 8:00 am and 5:00 pm, Monday through Friday:
range of d is dept 
range of e is employee 
define permit retrieve of e (ename, age, salary) 
    to ariane at "tta2" from 8:00 to 17:00 on mon to fri
    where e.dept=d.dno and d.mgr="ariane*"
Last modified date: 04/03/2024