babelfish-for-postgresql / babelfish_extensions / 11109596996

75%

push

github

grant on schema does not take effect on future objects created in a schema by schema's authorized users (#2993)

grant on schema does not take effect on future objects created in a schema by the schema's authorized users

When a user u1 is granted ownership on a schema s1 at the time of creation. And there is grant select on schema permission on s1 to u2. The future objects created by the users dbo and u1 should be accessible by the user u2

Earlier, if u1 created a table in s1 schema since it's authorized to do so, the user u2 was not allowed to access the object created by u1.

With this commit, future objects created by u1 and dbo will be accessible to the user u2.

Task: BABEL-5172

Signed-off-by: Shalini Lohia lshalini@amazon.com

60 of 113 new or added lines in 5 files covered. (53.1%)

45106 of 60569 relevant lines covered (74.47%)

162154.15 hits per line