PostgreSQL

Скачать в pdf «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»