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.
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 ...