A privilege is a right to execute a particular type of SQL statement. The type of privilege granted varies based on the type of role assigned to a user. Privileges help you to accomplish tasks required for their job.

The GRANT statement grants various privileges to the specified users of the database. There are two forms of the GRANT statement:
  • Grant database-wide privileges
  • Grant various privileges on specific tables and views