Difference between revisions of "Information schema"

Revision as of 15:22, 15 December 2022

select * from information_schema.role_table_grants where grantee='YOUR_USER';

psql -l

Revision as of 14:21, 14 December 2022 (edit) Ant (talk \| contribs) ← Older edit		Revision as of 15:22, 15 December 2022 (edit) (undo) Ant (talk \| contribs) Newer edit →
Line 1:		Line 1:
	{{lc}}		{{lc}}

		+
		+	select * from information_schema.[[role_table_grants]] where grantee='YOUR_USER';