SQL Grant Permissions: User Query Access Guide

To grant query permission to a user, you can use the following SQL statement:

Assign permission to user to only read data from the table in the specified database.

In which, database refers to the name of the database, table is the name of the table to be authorized, and user is the username to be authorized.

To grant a user permission to query all tables, you can use the following SQL statement:

Give user permission to select data from all tables in the database.

In this way, users can perform query operations on specified tables in a specified database or on all tables.