Re: Revoking table & function creation privileges
От | Mike Blackwell |
---|---|
Тема | Re: Revoking table & function creation privileges |
Дата | |
Msg-id | CANPAkgujL3LG3CPCJqHHUQjfAbMbhhLcdyiSSi2gLGcFx0gEJg@mail.gmail.com обсуждение исходный текст |
Ответ на | Revoking table & function creation privileges (Moshe Jacobson <moshe@neadwerx.com>) |
Список | pgsql-general |
The second line in the list of privilges shows the default grant of UC to "public" for that schema. Until you revoke that, the individual grants are superfluous.
On Thu, Aug 9, 2012 at 12:53 PM, Moshe Jacobson <moshe@neadwerx.com> wrote:
I posted this in Devshed forums (here) but no one seems to be responding. Hopefully someone here can help.How do I keep a user from being able to create tables in the public schema?
mjacobson@zeus=>[local]:ises=> \dn+ publicList of schemasName | Owner | Access privileges | Description--------+----------+----------------------+------------------------public | postgres | postgres=UC/postgres+| standard public schema| | =UC/postgres +|| | webuser=U/postgres |(1 row)
__________________________________________________________________________________
Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com
В списке pgsql-general по дате отправления: