O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required