REVOKE

4D Online Documentation Center

This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

4D SQL Reference
- SQL Commands
- - SQL Commands
  - SELECT
  - INSERT
  - UPDATE
  - DELETE
  - CREATE DATABASE
  - USE DATABASE
  - ALTER DATABASE
  - CREATE TABLE
  - ALTER TABLE
  - DROP TABLE
  - CREATE INDEX
  - DROP INDEX
  - LOCK TABLE
  - UNLOCK TABLE
  - EXECUTE IMMEDIATE
  - CREATE SCHEMA
  - ALTER SCHEMA
  - DROP SCHEMA
  - CREATE VIEW
  - DROP VIEW
  - GRANT
  - REVOKE
  - REPLICATE
  - SYNCHRONIZE

Home

4D v20 R8

4D SQL Reference

REVOKE

REVOKE



	REVOKE [READ \| READ_WRITE \| ALL] ON sql_name

Description

The REVOKE command can be used to remove specific access rights associated with the schema set by the sql_name parameter.

In fact, when you execute this command, you assign the <Nobody> pseudo-group of users to the specified access right.

Example

You want to delete all read-write access rights to the MySchema1 schema:

REVOKE READ_WRITE ON MySchema1

See also

Previous page

Next page

PROPERTIES

Product: 4D
Theme: SQL Commands

PAGE CONTENTS

Description

Example

HISTORY

ARTICLE USAGE

4D SQL Reference ( 4D v20 R8)

© 1985-2025 4D SAS / 4D, Inc. All rights reserved.

Add a comment