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.Let Dr. Droid create custom investigation plans for your infrastructure.
Start Free POC (15-min setup) →