The command to reclaim user operation permissions in sql is

下次还敢

Release： 2024-05-02 01:09:17

Original

587 people have browsed it

In SQL, the command to revoke user operation permissions is REVOKE, and its syntax is as follows: REVOKE [GRANT OPTION FOR] <Permissions> ON FROM . Permissions can be SELECT, INSERT, UPDATE, DELETE, CREATE, or DROP. The object can be a table, view, or procedure. Only users with administrator rights can reclaim the rights of other users.

The command to revoke user operation permissions in SQL

In SQL, the command to revoke user operation permissions isREVOKE.

Use REVOKE command

REVOKE The syntax of the command is as follows:

<code>REVOKE [GRANT OPTION FOR] <权限> ON <对象> FROM <用户></code>
Copy after login

Among them:

[GRANT OPTION FOR]: Optional parameter, specifying whether to also recycle options for granting permissions.

<Permissions>: The permission to be reclaimed can be one of the following:

SELECT

INSERT

UPDATE

DELETE

CREATE

DROP

##