Commitc7d8fd4

committed

Fix permission tests

1 parent6d9494d commitc7d8fd4Copy full SHA for c7d8fd4

File tree

-2

lines changed

-2

lines changed

Lines changed: 1 addition & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -19,8 +19,7 @@ GRANT SELECT ON permissions.user1_table TO user2;`
`19`	`19`	`/* Should fail (don't own parent) */`
`20`	`20`	`SET ROLE user2;`
`21`	`21`	`SELECT create_range_partitions('permissions.user1_table', 'id', 1, 10, 2);`
`22`		`-WARNING: only the owner or superuser can change partitioning configuration of table "user1_table"`
`23`		`-ERROR: new row violates row-level security policy for table "pathman_config"`
	`22`	`+ERROR: only the owner or superuser can change partitioning configuration of table "user1_table"`
`24`	`23`	`/* Should be ok */`
`25`	`24`	`SET ROLE user1;`
`26`	`25`	`SELECT create_range_partitions('permissions.user1_table', 'id', 1, 10, 2);`

Lines changed: 7 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -723,6 +723,13 @@ add_to_pathman_config(PG_FUNCTION_ARGS)`
`723`	`723`	`if (!check_relation_exists(relid))`
`724`	`724`	`elog(ERROR,"Invalid relation %u",relid);`
`725`	`725`
	`726`	`+if (!check_security_policy_internal(relid,GetUserId()))`
	`727`	`+{`
	`728`	`+elog(ERROR,"only the owner or superuser can change "`
	`729`	`+"partitioning configuration of table \"%s\"",`
	`730`	`+get_rel_name_or_relid(relid));`
	`731`	`+}`
	`732`	`+`
`726`	`733`	`/* Select partitioning type using 'range_interval' */`
`727`	`734`	`parttype=PG_ARGISNULL(2) ?PT_HASH :PT_RANGE;`
`728`	`735`

Comments

(0)