show Verified current stable Not installed? Security

Show / Show User Authorities

Show User Authorities

Use the 'show grants for {{username}};' command to view all privileges assigned to a specific user.

$
Terminal
show grants for <username>;

When To Use

Auditing user permissions before making system changes.

Terminal Output

Expected runtime feedback

Simulated preview
>
Output
GRANT SELECT ON database.table TO 'username';
GRANT INSERT ON database.table TO 'username';
GRANT UPDATE ON database.table TO 'username';

Command Breakdown

What each part is doing

show
Base Command
The executable that performs this operation. Here it runs Show before the shell applies any redirect operators.
<username>
username
The user value supplied to this command.

How To Run

Execution path

  1. Step 1

    Replace {{username}} with the actual username.

  2. Step 2

    Run the command 'show grants for {{username}};'.

  3. Step 3

    Review the output for user privileges.

Alternative Approaches

Comparable commands in other tools

Alternative security tools for the same job.