From: | me(at)nathanalden(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #7743: pgAdmin III does not list default privileges for schemas |
Date: | 2012-12-08 02:31:46 |
Message-ID: | E1ThACg-0008Ri-OL@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 7743
Logged by: Nathan Alden, Sr.
Email address: me(at)nathanalden(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | chris.jerdonek | 2012-12-08 13:41:30 | BUG #7744: docs should link to postgresql_psycopg2 |
Previous Message | me | 2012-12-08 02:29:30 | BUG #7742: Bug when backing up databases with default privileges defined on public schema |