PPT Slide
Other Data Definition Features (cont.)
- Authorization model for table hierarchies
- grant and revoke on table or subtables
- Substitutability: implicit subtable authorization on columns inherited from an authorized supertable
- Ex #1: select privilege on person table
- Ex #2: update privilege on salary column of emp table
- Some operations require authorization everywhere
- deref function
- is of type predicate and type_xxx functions
- SQL3 also supports granting of table/subtable privileges with hierarchy option