Re: set role command

2025-11-24 Thread Calvin Guo
allow it. On Mon, Nov 24, 2025 at 8:06 PM rob stone wrote: > On Mon, 2025-11-24 at 16:15 +0800, Calvin Guo wrote: > > I feel that set role logic is kindof misleading. > > > > I am a superuser, admin, > > I do: > > set role usera > > Now I am under the secur

set role command

2025-11-24 Thread Calvin Guo
I feel that set role logic is kindof misleading. I am a superuser, admin, I do: set role usera Now I am under the security context of usera, so I think running any sql is safe as long as it's allowed by usera. Which is not the case! as usera can do: set role userb; other sql, or reset role; orthe