Grant on object_type "tablespace" #371
Unanswered
OurFriendIrony
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
current version
I would like to grant access to a tablespace for a role that does not own the tablespace. For all granting access to various table related features, I would use the
postgresql_grant
resource, targeting a particular object_type. egHowever, "tablespace" is not a valid grant option for this resource.
I can see that the standard postgres syntax would be the same/similar to standard object types here:
Is there an equivalent implementation for tablespace grants that I'm unaware of, or possibly this feature is not currently available.
I can get around this by making the role a member of the role that owns the tablespace, but I want to be able to control the permissions more strictly.
Any advice welcome
Beta Was this translation helpful? Give feedback.
All reactions