pgtap icon indicating copy to clipboard operation
pgtap copied to clipboard

Any way to check VIEW privileges similar to table_privs_are?

Open jamesmbourne opened this issue 6 years ago • 2 comments

I am trying to test what privileges a user has on a view in the same way as has_table_privs, although from the docs I could not find a function that allows for this.

I tried using has_table_privs on the VIEW although this did not work:

Table example.view_here does not exist

Is this functionality that you would consider adding?

jamesmbourne avatar Feb 26 '19 11:02 jamesmbourne

Sure, makes sense. Care to submit a pull request?

theory avatar Feb 26 '19 15:02 theory

@theory Yeah I'll take a look at getting this implemented. I wasn't sure if I was just missing something in my usage of has_table_privs

jamesmbourne avatar Mar 02 '19 13:03 jamesmbourne