</>
sqlintermediate

GRANT - Technique 47

Grant roles and privileges

sql
WITH recent_orders AS (
  SELECT customer_id, SUM(total) AS spend
  FROM orders
  WHERE created_at >= now() - interval '30 days'
  GROUP BY customer_id
)
SELECT customer_id, spend
FROM recent_orders
ORDER BY spend DESC
LIMIT 10;

Use Cases

  • database operations
  • data management

Tags

#sql#database#grant

Related Snippets

Similar patterns you can reuse in the same workflow.

sqlintermediate

GRANT and REVOKE Permission Management

Manage database permissions with GRANT and REVOKE for roles, schemas, and tables.

Best for: database security

#sql#permissions
sqlbeginner

View - Technique 1

Create and manage database views

Best for: database operations

#sql#database
sqlintermediate

Index - Technique 2

Create and optimize database indexes

Best for: database operations

#sql#database
sqladvanced

Trigger - Technique 3

Create triggers for automatic actions

Best for: database operations

#sql#database