mirror of
https://gitea.com/mcereda/oam.git
synced 2026-02-08 21:34:25 +00:00
13 lines
275 B
SQL
13 lines
275 B
SQL
-- Get help
|
|
.help
|
|
|
|
-- View connections, tables & column information
|
|
.inspect
|
|
|
|
|
|
-- List AWS IAM users and their group
|
|
SELECT name FROM aws_iam_role
|
|
SELECT iam_user ->> 'UserName' AS User, name AS Group
|
|
FROM aws_iam_group
|
|
CROSS JOIN jsonb_array_elements(users) AS iam_user
|