Show current grants (basic)

SQL Easy 2 views
Back to Questions
Previous Grant execute on a procedure Easy P Next Read-only user for a whole schema Medium N

Problem Description

User analyst already exists. Write the SQL to check what privileges/grants are currently given to this user.

Input Format

SQL query

Output Format

Result set

Sample Test Case

Input:
User analyst exists
Output:
Grant list

Constraints

Command depends on your database
Please login to submit solutions and comments.

Solutions (0)

No solutions submitted yet. Be the first!

Discussion (0)

No comments yet. Start the discussion!

Prev Next