Ingres 11.0 | DEFINE PERMIT Example

QUEL Reference Guide > QUEL Reference Guide > QUEL and EQUEL Statements > DEFINE PERMIT--Add Table Permissions > DEFINE PERMIT Example

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: 01/30/2023