CRITICAL SKILL 1.7
Work with Object and System Privileges
It’s next to impossible to work with data in the Oracle Database 10g without looking at object privileges. In this section, we are going to look at these privileges as well as a suite of system privileges closely related to managing the Oracle Database 10g. The four main object privileges are select, insert, update, and delete, discussed in the next four sections. Oracle Database 10g uses the term grant when referring to giving out both object and system privileges.
Select
This is the primary and most commonly used privilege, permitting other users to view your data. There are three parts to grant statements:
1. The keywords grant select on.
2. The name of the object upon which the privileges ...
Get Oracle Database 10g: A Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
