On Fri, Mar 14, 2008 at 12:55 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Webb Sprague" <webb(dot)sprague(at)gmail(dot)com> writes:
> > Also, I revoked what I thought was everything possible on the public
> > schema, but a user is still able to create a table in that schema --
> > could someone explain:
>
> > oregon=# revoke create on schema public from foobar cascade;
> > REVOKE
>
> You've got a conceptual error here:
Not surprising...
<SNIP>
> Start with
> revoke all on schema public from public
> and then grant only what you want.
I will give it a go, and thanks!
>
> regards, tom lane
>