Managing users

From: "C G" <csgcsg39(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Managing users
Date: 2003-12-05 10:46:09
Message-ID: Law12-F73YNIPukg3nO0000dcca@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dear All,

Forgive me if this is a silly question, but I need some advice.

I'm setting up a db where users will be able to insert, update, select. I
will have three types of users. Lowest can do very little, highest to do
everything.

I'm thinking of creating three groups (Level1 to Level3) for the 3 types of
users. Is this the best way of doing this?

If a user logs on, say through a web interface, would I have a table with
username/passwd to check the login to the database? Or should I somehow use
the pg_user table?

Also, is there a way of monitoring how much memory a user takes up. For
example, I have a table username/Data. How much memory does each username
take up on that table?

Thanks for your time and help

Colin

_________________________________________________________________
Express yourself with cool emoticons - download MSN Messenger today!
http://www.msn.co.uk/messenger

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sai Hertz And Control Systems 2003-12-05 11:29:23 Re: Managing users
Previous Message Simon Chalmers 2003-12-05 06:51:00 Re: howto use pgencrypto ?