You already learned about creating different types of database objects.
Your Oracle database will store and manipulate these database objects to respond to user requests, but which users?
You can control who can access objects in the database and what they are allowed to do with those objects by assigning object privileges.
Object privileges are used to enforce security on the objects by limiting the type of access that any one user has to the objects.
Privilege : The capability to perform some type of database action.
In this module, you will learn about object privileges. By the end of this module, you will be able to:
Assign Oracle's object privileges
Grant other users access to your tables
Grant object privileges by using Security Manager
List the privileges that have been granted on a table
List the privileges that have been granted on columns and for users
WITH GRANT option
Revoke privileges once granted
All database systems require some type of security on the data they contain, and this module will give you all the information you need to design and
enforce a security scheme.