Table-Level Privileges

Use this page to manage privileges for users of individual tables in a database.

You can allow owner privileges on a table to users who do not own the table.

Database

Use this list to select the database that contains the table.

Table Name

The table that the user privilege applies to.

User

The user name of the user with the database-level privilege.

Grantor

The user name of the user who granted the privileges and who can cancel them.

Privileges

The table-level privileges for the user:

Select

Allows a user to retrieve the contents of the table, including temporary tables.

Update

Allows a user to modify existing rows.

Insert

Allows a user to add rows.

Delete

Allows a user to delete rows.

Index

Allows a user to create and alter indexes on the table. To use the Index privilege, the user must also have the Resource database-level privilege.

Alter

Allows a user to use the ALTER TABLE statement, including the ability to add and drop columns and reset the starting point for SERIAL columns.

Grant the Alter privilege only to users who understand the data model well.

References

Allows a user to impose referential constraints on a table. Grant the References privilege only to users who understand the data model well.

Under

Allows a user to create subtables under a typed table. The Under privilege is granted to PUBLIC automatically when a table is created except in ANSI-compliant databases.

Modify

To change the privileges for the user shown in the row, click Modify and select or clear the privileges.

Grant new privilege

To grant privileges to a user, enter the user name, select the table and the privileges, and click Grant.