Re: NULL pg_database.datacl

2023-03-20 Thread Dominique Devienne
On Mon, Mar 20, 2023 at 2:18 PM Erik Wienhold wrote: > > On 20/03/2023 13:50 CET Dominique Devienne wrote: > > > > On Mon, Mar 20, 2023 at 1:18 PM Erik Wienhold wrote: > > > > On 20/03/2023 11:52 CET Dominique Devienne > wrote: > > > > What does a NULL AclItem[] mean exactly? > > > > > > It m

Re: NULL pg_database.datacl

2023-03-20 Thread Erik Wienhold
> On 20/03/2023 13:50 CET Dominique Devienne wrote: > > On Mon, Mar 20, 2023 at 1:18 PM Erik Wienhold wrote: > > > On 20/03/2023 11:52 CET Dominique Devienne wrote: > > > What does a NULL AclItem[] mean exactly? > > > > It means that the object has default privileges (before any GRANT or REVOKE

Re: NULL pg_database.datacl

2023-03-20 Thread Dominique Devienne
On Mon, Mar 20, 2023 at 1:18 PM Erik Wienhold wrote: > > On 20/03/2023 11:52 CET Dominique Devienne wrote: > > What does a NULL AclItem[] mean exactly? > > It means that the object has default privileges (before any GRANT or REVOKE > is executed). For databases this means full privileges for th

Re: NULL pg_database.datacl

2023-03-20 Thread Erik Wienhold
> On 20/03/2023 11:52 CET Dominique Devienne wrote: > > Hi. I'm surprised, I thought ACLs would never be empty for a database. > Does that mean nobody can connect to this database? > I guess SUPERUSER and/or its datDBA can? > What does a NULL AclItem[] mean exactly? It means that the object has d