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  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-bugs
Дерево обсуждения
On Fri, Jun 30, 2017 at 12:18 PM, <zam6ak@gmail.com> wrote:
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.

https://www.postgresql.org/docs/9.6/static/sql-grant.html.

"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 по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: [BUGS] Re: BUG #14718: unable to update table with identity column GENERATEDALWAYS
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [BUGS] BUG #14724: Unable to revoke CREATE privileges on publicschema