6. QUEL and EQUEL Statements : Define Permit Statement--Add Table Permissions : Example
 
Share this page                  
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*"