The Grant statement is used to define access privileges. That is, it can be used to grant access to database objects such us tables, views , sequence etc..


Grant access to database object


Syntax: GRANT SELECT ON <schema>.<table-name> TO user

  • In place of SELECT we could have INSERT , UPDATE, DELETE etc.


  • In place of <schema>.<table-name> you could have a view name or a sequence etc.


  • Access privileges could be given to multiple users by comma separating them. Also could be given to a group etc.


Sources: