On 2021-Mar-08, Joel Jacobson wrote: > $ dropuser test > dropuser: error: removal of role "test" failed: ERROR: role "test" cannot be > dropped because some objects depend on it > DETAIL: 1 object in database joel > > Hmmm. I wonder which 1 object that could be?
BTW the easiest way to find out the answer to this question with current tech is to connect to database joel and attempt "DROP USER joel"; it will print a list of objects the user owns or has privileges for. > # SELECT * FROM pg_ownerships WHERE rolname = 'test'; > # SELECT * FROM pg_permissions WHERE grantee = 'test'; I wonder if these views should be defined on top of pg_shdepend instead of querying every single catalog. That would make for much shorter queries. -- Álvaro Herrera Valdivia, Chile
