On Fri, Mar 14, 2008 at 12:55 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "Webb Sprague" <webb.sprague@xxxxxxxxx> 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 > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
