Object Privileges

• Object Privileges vary from object to object.
• The owner has all the privileges.
• The owner can give specific privileges on that owner's object.

[ Syntax ]

GRANT object_priv [(columns)]
ON       object
TO       {user|role|PUBLIC}
[WITH GRANT OPTION]

- ALL : spcifies all object privileges.
- PUBLIC : grants object privileges to all users

[Ex]

GRANT select ON employees TO sue, rich;

GRANT update (department_name, location_id)
ON       departments
TO       scott, manager;

To grant privileges :
  - The object must be in your schema
  - Must have been granted the object privileges WITH GRANT OPTION.

An object owner can grant any object privileges on the object to any other user or role of the database.

Privileges with "WITH GRANT OPTION"
[ex]

GRANT    select, insert
ON          departments
TO          scott
WITH GRANT OPTION;

Allow all users on the system to query data

GRANT select
ON alice.departments
TO PUBLIC;