Hi, Quoting Johannes Schauer Marin Rodrigues (2024-06-16 23:10:45) > On Sat, 15 Jun 2024 22:48:30 +0200 Philipp Kern <pk...@debian.org> wrote: > > On 6/15/24 6:08 PM, Niels Thykier wrote: > > > In case it is relevant, I do not have access to the `transactions` table > > > (only the *_public ones): > > > > > > ``` > > > wanna-build=> select * from transactions where package = 'botch' and > > > state = 'Dep-Wait'; > > > ERROR: permission denied for table transactions > > > ``` > > > > I find that very surprising. I think it's because you connected to > > wanna-build without privileges. You'd have needed to use > > service=wanna-build-privileged to connect to actually ship a username. > > You're in wb_all, so you'd have been able to read that table. > > > > > Though, it might be that the answer is that we can solve this via a > > > "transactions_public" VIEW. I have no idea how feasible that is. > > > > That view exists now and access to it does not require user auth. > > could you or Philipp maybe hand-hold me so that I can learn how to look up > this sort of information now? I never did this. :)
okay, so for future-me or anybody else reading this: ssh wuiet.debian.org "psql service=wanna-build -P pager=off -c \"select * from transactions_public where package = 'botch' and state = 'Dep-Wait';\"" Thanks! cheers, josch
signature.asc
Description: signature
