CS338 Lecture 1: Notes
Document Summary
Dba can assign an owner to a whole schema by creating the schema and associating the appropriate authorization identifier with that schema, using the create. Owner account holder can pass privileges on any of the owned relations to other users by granting privileges to their accounts. In sql, the following types of privileges: Select (retrieval or read) privilege on r: gives an account retrieval privilege. In sql, this gives the account the privilege to use the select statement to retrieve tuples from r) Modification privileges on r: gives account capability to modify tuples of r. In sql this includes three privileges: update, delete, and insert. References privilege on r: gives account the capability to reference (or refer to) a relation r when specifying integrity constraints. In sql, the grant command is used to grant privileges to accounts. Example: grant update on employee (salary) to a4;