On 10/13/2017 11:21 AM, David G. Johnston wrote:
On Fri, Oct 13, 2017 at 11:03 AM, Igal @ Lucee.org >wrote:
You mean that if I execute the ALTER DEFAULT command above as user
`postgres` then only tables created by user `postgres` will give
On Fri, Oct 13, 2017 at 11:03 AM, Igal @ Lucee.org wrote:
> You mean that if I execute the ALTER DEFAULT command above as user
> `postgres` then only tables created by user `postgres` will give default
> privileges to role `webapp`?
>
Yes. "You can change default privileges
Stephen,
On 10/10/2017 6:14 AM, Stephen Frost wrote:
For future reference and for the benefit of others, the command that
I ran is:
ALTER DEFAULT PRIVILEGES IN SCHEMA public
GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO webapp;
Note that DEFAULT PRIVILEGES apply to a specific
Greetings,
* Igal @ Lucee.org (i...@lucee.org) wrote:
> It worked, thanks!
Be sure to check that you're really getting what you want here.
> For future reference and for the benefit of others, the command that
> I ran is:
>
> ALTER DEFAULT PRIVILEGES IN SCHEMA public
> GRANT SELECT,
On 10/9/2017 10:51 AM, David G. Johnston wrote:
On Mon, Oct 9, 2017 at 9:44 AM, Igal @ Lucee.org >wrote:
But I want to give that role permissions on future tables since I
add new tables and drop/recreate current ones.
ALTER DEFAULT PRIVILEGES
On Mon, Oct 9, 2017 at 9:44 AM, Igal @ Lucee.org wrote:
> But I want to give that role permissions on future tables since I add new
> tables and drop/recreate current ones.
>
ALTER DEFAULT PRIVILEGES
https://www.postgresql.org/docs/9.6/static/sql-alterdefaultprivileges.html
Hello,
I created a role named `webapp` as follows:
CREATE ROLE webapp WITH LOGIN PASSWORD 'changeme';
While in development, I want to give that role permissions on all tables
in schema public. So far I've been using the following command, which
works on existing tables:
GRANT ALL