Commitb34f8f4

committed

Show schemas in information_schema.schemata that the current has access to

Before, it would only show schemas that the current user owns. Perdiscussion, the new behavior is more useful and consistent for PostgreSQL.

1 parent71901ab commitb34f8f4Copy full SHA for b34f8f4

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -4547,8 +4547,9 @@ ORDER BY c.ordinal_position;`
`4547`	`4547`	`<title><literal>schemata</literal></title>`
`4548`	`4548`
`4549`	`4549`	`<para>`
`4550`		`- The view <literal>schemata</literal> contains all schemas in the`
`4551`		`- current database that are owned by a currently enabled role.`
	`4550`	`+ The view <literal>schemata</literal> contains all schemas in the current`
	`4551`	`+ database that the current user has access to (by way of being the owner or`
	`4552`	`+ having some privilege).`
`4552`	`4553`	`</para>`
`4553`	`4554`
`4554`	`4555`	`<table>`

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1502,7 +1502,9 @@ CREATE VIEW schemata AS`
`1502`	`1502`	`CAST(nullAS sql_identifier)AS default_character_set_name,`
`1503`	`1503`	`CAST(nullAS character_data)AS sql_path`
`1504`	`1504`	`FROM pg_namespace n, pg_authid u`
`1505`		`-WHEREn.nspowner=u.oidAND pg_has_role(n.nspowner,'USAGE');`
	`1505`	`+WHEREn.nspowner=u.oid`
	`1506`	`+AND (pg_has_role(n.nspowner,'USAGE')`
	`1507`	`+OR has_schema_privilege(n.oid,'CREATE, USAGE'));`
`1506`	`1508`
`1507`	`1509`	`GRANTSELECTON schemata TO PUBLIC;`
`1508`	`1510`

Comments

(0)