Re: limiting connections per user/database

On Sun, 2005-06-26 at 20:52 +0200, Petr Jelínek wrote:
> Alvaro Herrera wrote:
>
> >I don't think this approach is very user-friendly.  I'd vote for the
> >catalog approach, I think.
> >
> >
> Ok I am fine with both but catalog changes would mean more hacking of
> ALTER DATABASE and ALTER USER.

IMHO Oracle has better solution for per-user setting:

CREATE PROFILE <name>
   SESSIONS_PER_USER <int>
   CONNECT_TIME <int>
   IDLE_TIME <int>;

ALTER USER <name> PROFILE <name>;


    karel

--
Karel Zak <zakkr@zf.jcu.cz>