Privileges on Relations

  1. SELECT (retrieval or read) Privilege on R.

    Gives the account retrieval privilege. In SQL this gives the account the privilege to use the SELECT statement to retrieve tuples from R.

  2. Modification Privileges on R.

    This gives the account the capability to modify the tuples of R. In SQL this includes three privileges: UPDATE, DELETE , and INSERT. Additionally, both the INSERT and UPDATE privileges can specify that only certain attributes of R can be modified by the account.

  3. References Privilege on R.

    This gives the account the capability to reference (or refer to) a relation R when specifying integrity constraints. This privilege can also be restricted to specific attributes of R.

To create a View, the account must have the SELECT privilege on all relations involved in the View definition in order to specify the query that corresponds to the View.