Revoke privileges

sql

REVOKE DELETE ON app_db.* FROM 'app_user'@'%';

Explanation

Use revoke to tighten access when an account should no longer perform certain operations.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing grants and roles

Allow an app account to use one schema.

Open In sheetsqlsame section

Inspect the effective privileges granted to an account.

Open In sheetsqlsame section

Give broad schema-level rights.

Open In sheetsqlsame section

Refresh privilege data after direct system-table changes.

Open In sheetsqlsame section

Create an account identified by user name and host.

Rotate credentials for an existing account.