Ashesh,Thanks. I found these dialogs via the Object tab. However, they still do not show the revoke execute on functions from public for the role. I don't see any indication for for this. ALTER DEFAULT PRIVILEGES FOR ROLE some_role REVOKE EXECUTE ON FUNCTIONS FROM PUBLIC:Where does that appear?
On Tue, May 14, 2019 at 12:43 AM Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:On Mon, May 13, 2019 at 8:18 PM Michael Shapiro <mshapiro51@gmail.com> wrote:default privileges can be applied to roles (and, it appears, only to roles)https://www.postgresql.org/docs/10/sql-alterdefaultprivileges.htmlYou can find the default priviledges on the database, and schema properties dialog.--Thanks & Regards,Ashesh VashiEnterpriseDB INDIA: Enterprise PostgreSQL Companyhttp://www.linkedin.com/in/asheshvashiALTER 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
On Mon, May 13, 2019 at 8:18 PM Michael Shapiro <mshapiro51@gmail.com> wrote:default privileges can be applied to roles (and, it appears, only to roles)https://www.postgresql.org/docs/10/sql-alterdefaultprivileges.htmlYou can find the default priviledges on the database, and schema properties dialog.--Thanks & Regards,Ashesh VashiEnterpriseDB INDIA: Enterprise PostgreSQL Companyhttp://www.linkedin.com/in/asheshvashiALTER 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
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 by date:
Соглашаюсь с условиями обработки персональных данных