Release Notes
- v3.1
- v3.0
- v2.5
- v2.4
- v2.3
- v2.2
- v2.1
- v2.0
- v1.19

StarRocks
Introduction to StarRocks
Quick Start
Table Design
- Understand StarRocks table design
- Data models
- Data distribution
  - Data distribution
  - Temporary partition
- Sort keys and prefix indexes
Data Loading
Data Unloading
Query Data Sources
- Use catalogs to manage internal and external data
- External tables
Query Acceleration
Administration
- Deployment
- Management
- Data Recovery
  - Data recovery
  - Restore FEs
- User Privilege and Authentication
  - User privilege
  - Authentication
- Performance Tuning
Reference
- SQL Reference
- Function Reference
  - Java UDFs
  - Window functions
  - Aggregate Functions
  - Array Functions
  - Bit Functions
  - Bitmap Functions
  - Conditional Functions
  - Cryptographic Functions
  - Date Functions
  - Geographic Functions
  - JSON Functions
    - Overview of JSON functions and operators
    - JSON operators
    - JSON constructor functions
    - JSON query and processing functions
  - Math Functions
    - abs
    - acos
    - asin
    - atan
    - atan2
    - bin
    - ceil
    - ceiling
    - conv
    - cos
    - cosh
    - cot
    - degrees
    - divide
    - e
    - exp
    - floor
    - fmod
    - greatest
    - least
    - ln
    - log
    - log2
    - log10
    - mod
    - multiply
    - negative
    - pi
    - pmod
    - positive
    - pow
    - radians
    - rand
    - round
    - sign
    - sin
    - sqrt
    - square
    - tan
    - truncate
  - String Functions
  - Pattern Matching Functions
  - Percentile Functions
  - Scalar Functions
    - hll_cardinality
  - Utility Functions
  - cast function
  - hash function
- System variables
- Error code
- System limits
FAQ
- Deploy
- Data Migration
  - Data Loading
  - Data Unloading
- SQL
- Other FAQs
Benchmark
- SSB Benchmark
- TPC-H Benchmark

Developers
- Contribute to StarRocks
- Code Style Guides
  - protobuf style guides
  - thrift style guides
- Use the debuginfo file for debugging
- Development Environment
- Trace Tools
  - Trace

Edit

SHOW GRANTS

Description

This statement is used to view user permissions.

Syntax:

SHOW [ALL] GRANTS [FOR user_identity]

Note:

1. SHOW ALL GRANTS can view the privileges of all users. 
2. When user_identity is specified, the permissions of the user thus specified will be showed. Meanwhile, this user_identity must be created through CREATE USER command. 
3. When user_identity is not specified, the permissions of the current user will be showed.

Examples

View all users' permissions.
```
SHOW ALL GRANTS; 
```
View specified users' permissions.
```
SHOW GRANTS FOR jack@'%';
```
View the current user's permissions.
```
SHOW GRANTS;
```

Edit

In this article

SHOW GRANTS
- Description
- Examples