> > The connect group would be granted these System Privileges: If we keep it like others (e.g. Informix) this System Privilege would be called "resource". I like this name better, because it more describes the detailed priviledges. > > > > CREATE AGGREGATE privilege > > CREATE INDEX privilege > > CREATE FUNCTION privilege > > CREATE OPERATOR privilege > > CREATE RULE privilege > > CREATE SESSION privilege > > CREATE SYNONYM privilege > > CREATE TABLE privilege > > CREATE TRIGGER privilege > > CREATE TYPE privilege > > CREATE VIEW privilege The "connect" group would only have the priviledge to connect to the db [and create temp tables ?] and rights they where granted, or that were granted to public. They would not be allowed to create anything. Andreas ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
