PostgreSQL

Notes

See also SET and SHOW to manipulate variable values.

Usage

Set DateStyle to its default value:

RESET DateStyle;

Set Geqo to its default value:

RESET GEQO;

Compatibility

SQL92

There is no RESET in SQL92.

D.76 REVOKE

Name

REVOKE — Revokes access privilege from a user, a group or all users.

REVOKE privilege [,…]

ON object [,…]

FROM { PUBLIC I GROUP groupname | username }

Inputs

privilege The possible privileges are:

SELECT Privilege to access all of the columns of a specific table/view.

INSERT Privilege to insert data into all columns of a specific table.

UPDATE Privilege to update all columns of a specific table.

DELETE Privilege to delete rows from a specific table.

RULE Privilege to define rules on table/view. (See CREATE RULE).

ALL Rescind all privileges.

object The name of an object from which to revoke access. The possible objects are:

•    table

•    view

•    sequence

group The name of a group from whom to revoke privileges.

username The name of a user from whom revoke privileges. Use the PUBLIC keyword to specify all users.

PUBLIC Rescind the specified privilege(s) for all users.

Outputs

CHANGE Message returned if successfully.

ERROR Message returned if object is not available or impossible to revoke privileges from a group or users.

Description

REVOKE allows creator of an object to revoke permissions granted before, from all users (via PUBLIC) or a certain user or group.

Скачать в pdf «PostgreSQL»