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
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 ? |