Unix/Linux Go Back    


RedHat 9 (Linux i386) - man page for revoke (redhat section 7)

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:   man
Select Man Page Set:       apropos Keyword Search (sections above)


REVOKE(7)				   SQL Commands 				REVOKE(7)

NAME
       REVOKE - remove access privileges

SYNOPSIS
       REVOKE { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER }
	   [,...] | ALL [ PRIVILEGES ] }
	   ON [ TABLE ] tablename [, ...]
	   FROM { username | GROUP groupname | PUBLIC } [, ...]

       REVOKE { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }
	   ON DATABASE dbname [, ...]
	   FROM { username | GROUP groupname | PUBLIC } [, ...]

       REVOKE { EXECUTE | ALL [ PRIVILEGES ] }
	   ON FUNCTION funcname ([type, ...]) [, ...]
	   FROM { username | GROUP groupname | PUBLIC } [, ...]

       REVOKE { USAGE | ALL [ PRIVILEGES ] }
	   ON LANGUAGE langname [, ...]
	   FROM { username | GROUP groupname | PUBLIC } [, ...]

       REVOKE { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
	   ON SCHEMA schemaname [, ...]
	   FROM { username | GROUP groupname | PUBLIC } [, ...]

DESCRIPTION
       REVOKE  allows  the creator of an object to revoke previously granted permissions from one
       or more users or groups of users.  The key word PUBLIC refers to  the  implicitly  defined
       group of all users.

       Note  that  any	particular  user will have the sum of privileges granted directly to him,
       privileges granted to any group he is presently a member of,  and  privileges  granted  to
       PUBLIC. Thus, for example, revoking SELECT privilege from PUBLIC does not necessarily mean
       that all users have lost SELECT privilege  on  the  object:  those  who	have  it  granted
       directly or via a group will still have it.

       See  the  description  of  the  GRANT  [grant(7)] command for the meaning of the privilege
       types.

NOTES
       Use psql(1)'s \z command to display the privileges granted on existing objects.	See  also
       GRANT [grant(7)] for information about the format.

EXAMPLES
       Revoke insert privilege for the public on table films:

       REVOKE INSERT ON films FROM PUBLIC;

       Revoke all privileges from user manuel on view kinds:

       REVOKE ALL PRIVILEGES ON kinds FROM manuel;

COMPATIBILITY
   SQL92
       The  compatibility  notes of the GRANT [grant(7)] command apply analogously to REVOKE. The
       syntax summary is:

       REVOKE [ GRANT OPTION FOR ] { SELECT | INSERT | UPDATE | DELETE | REFERENCES }
	   ON object [ ( column [, ...] ) ]
	   FROM { PUBLIC | username [, ...] }
	   { RESTRICT | CASCADE }

       If user1 gives a privilege WITH GRANT OPTION to user2, and user2 gives it  to  user3  then
       user1  can  revoke  this privilege in cascade using the CASCADE keyword.  If user1 gives a
       privilege WITH GRANT OPTION to user2, and user2 gives it to user3, then if user1 tries  to
       revoke this privilege it fails if he specifies the RESTRICT keyword.

SEE ALSO
       GRANT [grant(7)]

SQL - Language Statements		    2002-11-22					REVOKE(7)
Unix & Linux Commands & Man Pages : ©2000 - 2018 Unix and Linux Forums


All times are GMT -4. The time now is 07:48 AM.