SELECT current_user;
SHOW is_superuser;
SELECT * FROM information_schema.role_table_grants WHERE grantee = current_user;
SELECT grantee, privilege_type
FROM information_schema.table_privileges
WHERE table_name = 'your_table_name';
SELECT grantee, privilege_type
FROM information_schema.schema_privileges
WHERE schema_name = 'your_schema_name';
GRANT SELECT ON your_table_name TO your_role_name;
SELECT with the needed privilege (e.g., INSERT, UPDATE, DELETE) and adjust your_table_name and your_role_name as necessary.GRANT OPTION on the object.(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)
