JAEN

SQL

SHOW GRANTS

SafeShow grants

SHOW GRANTS FOR 'user'@'host';

Lists a user's privileges — the tool for permission errors and periodic audits.

Examples

  • SHOW GRANTS FOR 'webapp'@'%';Audit the app user

Syntax

SHOW GRANTS [FOR 'user'@'host'];

Before you run it

Read only.

Related commands

The same reference, with no signal at all

Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.

Get it free on the App Store