[Dbconfig-common-devel] Read only access for all users to database

[Paul Gevers]

Hi Kip,

On 07-06-16 20:53, Paul Gevers wrote:
> On 07-06-16 06:33, Kip Warner wrote:
>> My question was about the package that actually installs the schema
>> into PSQL / MySQL and "hosts" the database.
> 
> Pardon my ignorance, but I don't understand what you mean by this (no
> idea what it means if a package hosts a database). If the package is
> using dbconfig-common, there is no way to guarantee that it is used on
> the same computer that hosts the database. So maybe dbconfig-common is
> not for your package (I can't really say), or you need to be very
> explicit in you description of the package that the admin must never
> tell dbconfig-common to "install the schema" onto a different host.
> Whatever the answer, I guess there is no dbconfig-common way to do what
> you originally asked for.

The other day I had an idea. Maybe what you are looking for is the
native support that dbconfig-common has for install/upgrade scripts.
What you could do is feed dbconfig-common with a script, check if the
database is localhost and then do what you want.

On the other hand, you may be looking for a native PostgreSQL solution
to grant the access to all users. I.e. what I assume you want is that
when a user gets added to the system, he automatically has access. I
wouldn't know how to do that.

Paul

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL: <http://lists.alioth.debian.org/pipermail/dbconfig-common-devel/attachments/20160610/f4d23332/attachment.sig>