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

[Paul Gevers]

Hi Kip

On 30-05-16 23:49, Kip Warner wrote:
> On Sun, 2016-04-17 at 15:26 -0700, Kip Warner wrote:
>> All I want to know is how to allow all system users read only access 
>> to the database on the machine hosting the database that dbconfig
>> -common created when dbc_go was invoked in the myapplication
>> -database.config script.
> 
> Hey Paul,
> 
> I'm still having this problem. All I want is for another system user to
> authenticate as the PostgreSQL dbc_dbuser (role).
> 
> According to this, dbconfig-common can create database users:
> 
>     https://people.debian.org/~seanius/policy/dbconfig-common.html/ch-in
>     tro.html
> 
> If this is outside of the realm of dbconfig-common, is there a generic
> recommended recipe for doing this through maybe a postinst hook?

As said, I believe this is outside of the realm of dbconfig-common. I am
not sure that it is possible what you want, because on the system where
you run dbconfig-common, there may be no way at all to know the system
users of the system hosting the database.

If you believe it may be doable within PostgreSQL, I am really no expert
(barely a user even) of PostgreSQL, so then I believe you should seek
your help elsewhere.

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/20160603/5dc31f5f/attachment.sig>