Oracle SQL in 10 Minutes - Asim Abbasi
CH1: SQL Basics | CH2: SQL Operators | CH3: SQL Built-in Functions | CH4: SQL Joins | CH5: UPDATE, INSERT & DELETE Statements | CH6: CREATE, ALTER & DROP Statements | CH7: Constraints | CH8: Linking Tables vs Joining Tables | CH9: SQL Statements for Other Database Objects | CH10: SQL Statements for Database Security
Chapter 10: SQL Statements for Database Security
There are two kinds of privileges, one is called “Object Privileges” and
the other one is called “System Privileges”. The complete list of each
of these object privileges is given below along with their application.
ALTER Table, Sequence
DELETE Table, View
INDEX Table
INSERT Table, View
READ Dictionary
REFERENCE Table
SELECT Table, Sequence, View
UPDATE Table, View
EXECUTE PL/SQL Objects e.g. Functions, Package etc.
The way to interpret this table is, if you keep the above example in
your mind, you can grant ALTER, DELETE object privilege on any table but
you cannot grant READ on any table. This implies to EXECUTE, one cannot
grant EXECUTE privilege on any table, view etc. its only meant for
PL/SQL objects.
Chapter 10: SQL Statements for Database Security
CH1: SQL Basics | CH2:
SQL Operators |
CH3: SQL Built-in Functions | CH4:
SQL Joins | CH5:
UPDATE, INSERT & DELETE Statements |
CH6: CREATE, ALTER & DROP Statements | CH7:
Constraints | CH8:
Linking Tables vs Joining Tables | CH9:
SQL
Statements for Other Database Objects | CH10:
SQL Statements for
Database Security Share with others: