Обсуждение: BUG #7743: pgAdmin III does not list default privileges for schemas

Поиск
Список
Период
Сортировка

BUG #7743: pgAdmin III does not list default privileges for schemas

От
me@nathanalden.com
Дата:
The following bug has been logged on the website:

Bug reference:      7743
Logged by:          Nathan Alden, Sr.
Email address:      me@nathanalden.com
PostgreSQL version: 9.2.2
Operating system:   Windows 7 x64
Description:        =


Follow these steps to reproduce:

1. Connect to the postgres DB.
2. Run the following SQL: =


create database test_database;

3. Run the following SQL:

create role my_group;

4. Connect to the test_database DB.
5. Run the following SQL:

alter default privileges in schema public grant all on types to my_group;

6. Open pgAdmin III.
7. Navigate to the public schema in test_database.
8. Right-click the public schema and choose Properties.
9. Select the Default Privileges tab.
10. Note that all four subtabs are empty, and the Role drop-down lists do
not list my_group as a role.