Database Reference
In-Depth Information
Figure 13-10.
Object Privileges
The
Grant
statement is used to issue object privileges. When used for this purpose,
the following rules apply:
•
The
ON-Clause
is required.
•
The privilege specified must be an object privilege, or the
keyword ALL.
Example 11:
The following examples assume the prior creation of the user accounts
specified:
Example 12:
The following statement revokes UPDATE privilege on table Student,
for user
BruceJones
.
Security via Views
As stated in the previous section, views can be used to enhance system security by
allowing users to access only what is relevant to them. Conversely, views can be used to
prevent users from accessing data for which they have no access privilege.