Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
default privileges can be applied to roles (and, it appears, only to roles)https://www.postgresql.org/docs/10/sql-alterdefaultprivileges.html
--
Thanks & Regards,Ashesh VashiEnterpriseDB INDIA: Enterprise PostgreSQL Company
http://www.linkedin.com/in/asheshvashi
ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ] [ IN SCHEMA schema_name [, ...] ] abbreviated_grant_or_revokeOn Mon, May 13, 2019 at 4:58 AM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:On Mon, May 13, 2019 at 3:06 PM Michael Shapiro <mshapiro51@gmail.com> wrote:I ran this in one of my databases ALTER DEFAULT PRIVILEGES FOR ROLE some_role REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC:I can not see this default privilege anywhere in PgAdmin4 (nor in PgAdmin3).I see no default privileges for roles on the SQL for the role.Default privileges can be applied on tables, sequences, types and on functions only, so why roles?I do see default privileges on the SQL for the database itself, but not the one I added above. You can create this bug @ https://redmine.postgresql.org/projects/pgadmin4 with the proper steps to reproduce it. (Also, the last example on the help page show creating an EDB role, but the discussion below talks about a role called "alice")On Sun, May 12, 2019 at 11:56 PM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:On Sun, May 12, 2019 at 7:42 PM Michael Shapiro <mshapiro51@gmail.com> wrote:Where in PgAdmin4 can I see (and set) default privileges for a role?Please refer https://www.pgadmin.org/docs/pgadmin4/4.x/role_dialog.html?highlight=Privileges
ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ] [ IN SCHEMA schema_name [, ...] ] abbreviated_grant_or_revoke
target_role
schema_name
abbreviated_grant_or_revoke
On Mon, May 13, 2019 at 3:06 PM Michael Shapiro <mshapiro51@gmail.com> wrote:I ran this in one of my databases ALTER DEFAULT PRIVILEGES FOR ROLE some_role REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC:I can not see this default privilege anywhere in PgAdmin4 (nor in PgAdmin3).I see no default privileges for roles on the SQL for the role.Default privileges can be applied on tables, sequences, types and on functions only, so why roles?I do see default privileges on the SQL for the database itself, but not the one I added above. You can create this bug @ https://redmine.postgresql.org/projects/pgadmin4 with the proper steps to reproduce it. (Also, the last example on the help page show creating an EDB role, but the discussion below talks about a role called "alice")On Sun, May 12, 2019 at 11:56 PM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:On Sun, May 12, 2019 at 7:42 PM Michael Shapiro <mshapiro51@gmail.com> wrote:Where in PgAdmin4 can I see (and set) default privileges for a role?Please refer https://www.pgadmin.org/docs/pgadmin4/4.x/role_dialog.html?highlight=Privileges
I ran this in one of my databases ALTER DEFAULT PRIVILEGES FOR ROLE some_role REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC:I can not see this default privilege anywhere in PgAdmin4 (nor in PgAdmin3).I see no default privileges for roles on the SQL for the role.
I do see default privileges on the SQL for the database itself, but not the one I added above.
(Also, the last example on the help page show creating an EDB role, but the discussion below talks about a role called "alice")On Sun, May 12, 2019 at 11:56 PM Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:On Sun, May 12, 2019 at 7:42 PM Michael Shapiro <mshapiro51@gmail.com> wrote:Where in PgAdmin4 can I see (and set) default privileges for a role?Please refer https://www.pgadmin.org/docs/pgadmin4/4.x/role_dialog.html?highlight=Privileges
On Sun, May 12, 2019 at 7:42 PM Michael Shapiro <mshapiro51@gmail.com> wrote:Where in PgAdmin4 can I see (and set) default privileges for a role?Please refer https://www.pgadmin.org/docs/pgadmin4/4.x/role_dialog.html?highlight=Privileges
Where in PgAdmin4 can I see (and set) default privileges for a role?
В списке pgadmin-support по дате отправления: