Re: How to set default privilege for new users to have no access to other databases?

2023-08-12 Thread Peter J. Holzer
On 2023-08-09 14:35:40 -0400, Erik Nelson wrote: > I have a lab with a database that I would like to use as a "multi-tenant" > database, in that I would like to create a database for each of the > applications that I'm running and segregate access so that user foo and user > bar cannot see

Re: How to set default privilege for new users to have no access to other databases?

2023-08-10 Thread David G. Johnston
On Wednesday, August 9, 2023, Erik Nelson wrote: > I have a lab with a database that I would like to use as a "multi-tenant" > database, in that I would like to create a database for each of the > applications that I'm running and segregate access so that user foo and > user bar cannot see

How to set default privilege for new users to have no access to other databases?

2023-08-10 Thread Erik Nelson
I have a lab with a database that I would like to use as a "multi-tenant" database, in that I would like to create a database for each of the applications that I'm running and segregate access so that user foo and user bar cannot see anything about their neighbors. I'm somewhat surprised to