Hi, thanks again Niels for filing a bug for the question I had on IRC. :)
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. :) Thanks! cheers, josch
signature.asc
Description: signature
