PERMIT(QUEL) 2/7/79 PERMIT(QUEL) NAME permit - add permissions to a relation SYNOPSIS define permit oplist { on | of | to } var [ (attlist) ] to name [ at term ] [ from time to time ] [ on day to day ] [ where qual ] DESCRIPTION The permit statement extends the current permissions on the relation specified by var. Oplist is a comma separated list of possible operations, which can be retrieve, replace, delete, append, or all; all is a special case meaning all permissions. Name is the login name of a user or the word all. Term is a terminal name of the form `ttyx' or the keyword all; omitting this phrase is equivalent to specifying all. Times are of the form `hh:mm' on a twenty- four hour clock which limit the times of the day during which this permission applies. Days are three-character abbreviations for days of the week. The qual is appended to the qualification of the query when it is run. Separate parts of a single permit statement are conjoined (ANDed). Different permit statements are disjoined (ORed). For example, if you include . . . to eric at tty4 . . . the permit applies only to eric when logged in on tty4, but if you include two permit statements . . . to eric at all . . . . . . to all at tty4 . . . then when eric logs in on tty4 he will get the union of the permissions specified by the two statements. If eric logs in on ttyd he will get only the permissions specified in the first permit statement, and if bob logs in on tty4 he will get only the permissions specified in the second permit statment. The permit statement may only be issued by the owner of the relation. Although a user other than the DBA may issue a permit statement, it is useless because noone else can access her relations anyway. Permit statements do not apply to the owner of a relation or to views. - 1 - PERMIT(QUEL) 2/7/79 PERMIT(QUEL) The statements define permit all on x to all define permit retrieve of x to all with no further qualification are handled as special cases and are thus particularly efficient. EXAMPLES range of e is employee define permit retrieve of e (name, sal) to marc at ttyd from 8:00 to 17:00 on Mon to Fri where e.mgr = "marc" range of p is parts define permit retrieve of e to all SEE ALSO destroy(quel) - 2 -