Table of Contents

NAME

grant -- grant access control to a user or group

SYNOPSIS

grant <privilege[,privilege,...]>
   on <rel1>[,...<reln>]
   to [public | group <group> | <username>]

   privilege is {ALL | SELECT | INSERT | UPDATE | DELETE | RULE }

DESCRIPTION

Grant allows you to give specified permissions to all users or a certain user or group. By default, a table grants read-only (SELECT ) to all Postgres users. You must specifically revoke this privilege if this is not desired.

EXAMPLES

--
--Example of a grant
--
grant insert
   on mytab
   to public

SEE ALSO

revoke(l)

Table of Contents