Re: Best Practices for Extensions, limitations and recommended use for monitoring

2018-08-14 Thread Alvar Freude
Hi Tom, > Am 14.08.2018 um 17:07 schrieb Tom Lane : > > I'd say that's generally deprecated. Per the documentation, you can write > CREATE USER commands in an extension script if you like, but the roles > won't be considered to "belong" to the extension, and won't be dropped > when it is. This

Re: Best Practices for Extensions, limitations and recommended use for monitoring

2018-08-14 Thread Tom Lane
Alvar Freude writes: > I have a question about best practices writing PostgreSQL extensions. Is it > OK to write extensions which create users and grant/revoke rights on the > created functions to this users? I'd say that's generally deprecated. Per the documentation, you can write CREATE USER

Best Practices for Extensions, limitations and recommended use for monitoring

2018-08-14 Thread Alvar Freude
Hi all, I have a question about best practices writing PostgreSQL extensions. Is it OK to write extensions which create users and grant/revoke rights on the created functions to this users? Is it possible to add options to CREATE EXTENSION by the extension itself e.g. to make user names configu