Re: How to prevent a user from dropping/creating a database

2003-04-03 Thread Chris Jaeger
Jeremy Zawodny wrote: On Wed, Apr 02, 2003 at 01:46:00PM -0800, Chris Jaeger wrote: Hi all, I'm wondering if there is some way to setup privileges in the grant tables such that a user can create or drop any arbitrary table in databases that user is associated with, but be unable to create or

Re: How to prevent a user from dropping/creating a database

2003-04-03 Thread Jeremy Zawodny
On Wed, Apr 02, 2003 at 01:46:00PM -0800, Chris Jaeger wrote: > Hi all, > > I'm wondering if there is some way to setup privileges in the grant > tables such that a user can create or drop any arbitrary table in > databases that user is associated with, but be unable to create or drop > t

How to prevent a user from dropping/creating a database

2003-04-02 Thread Chris Jaeger
Hi all, I'm wondering if there is some way to setup privileges in the grant tables such that a user can create or drop any arbitrary table in databases that user is associated with, but be unable to create or drop the databases themselves. I was hoping the tables_priv table would come to my r