On Tue, Oct 22, 2002 at 21:01:59 +0200, Gabor Faludi <[EMAIL PROTECTED]> wrote: > I've been searching the web for a solution on this but no luck . > > I'm administering a webserver w/ PHP apps on . I had an idea to create an > application database and give access to certain users to maintain the data > within the database tables , but also I'd like to make sure only certain > users are able to perform DDL commands. Or simply to revoke access for > connecting to this db.
In 7.3 you can get a pretty good handle on this. The database owner can restrict who can create schemas and schema owners can control who can create objects in that schema. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
