Syntax
GRANT { SELECT | INSERT | UPDATE | DELETE | ALL }
ON tablename
TO
{ User | {GROUP|ROLE} groupname | PUBLIC } [, ...] [ WITH GRANT OPTION ];
Description
With GRANT you can give following rights or privileges to database users or roles (groups of users):
SELECT - revtrieve or query data
INSERT - insert new records into a table
UPDATE - modify datafields in a table
DELETE - delete records from a table
ALL - means all rights on a table
When PUBLIC is used instead of a list of concrete users or roles, then the specifyed priviledges will be given to all users of the database system (depending on the used RDMBS the rights are given only to the users woth connect permission to the current database).