Re: [BUGS] BUG #14724: Unable to revoke CREATE privileges on public schema
| От | David G. Johnston |
|---|---|
| Тема | Re: [BUGS] BUG #14724: Unable to revoke CREATE privileges on public schema |
| Дата | |
| Msg-id | CAKFQuwa-jBUUE0ZAcsRb9j33a-pJdqrDa9QqQeoUoVgaQrJf6g@mail.gmail.com обсуждение исходный текст |
| Ответ на | [BUGS] BUG #14724: Unable to revoke CREATE privileges on public schema (zam6ak@gmail.com) |
| Ответы |
Re: [BUGS] BUG #14724: Unable to revoke CREATE privileges on publicschema
|
| Список | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 14724
Logged by: zam6ak
Email address: zam6ak@gmail.com
PostgreSQL version: 10beta1
Operating system: Windows Server 2012
Description:
-- create a test db
CREATE DATABASE test
WITH OWNER = postgres
ENCODING = 'UTF8';
-- log in as 'postres' and do:
REVOKE CREATE ON SCHEMA public FROM public;
WARNING: no privileges could be revoked for "public"
Query returned successfully with no result in 16 msec.
"No privileges are granted to PUBLIC by default on tables, columns, schemas or tablespaces."
You've been correctly warned that you've attempted to revoke a privilege that doesn't exist.
David J.
В списке pgsql-bugs по дате отправления: