Re: [GENERAL] Revoking table & function creation privileges

2012-08-09 Thread Mike Blackwell
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 wrote: > I posted this in Devshed forums > (here

[GENERAL] Revoking table & function creation privileges

2012-08-09 Thread Moshe Jacobson
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? I have tried REVOKE CRE