Re: Managing users

Dear C G ,

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

Forgiveness granted :-)

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

Yes without doubt to my experience this is a better method

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

Considering you are using PHP +PostgreSQL

You can use the pg_user table
Just you have to do is
1. Make two cookies variable each storing the password and user name
2. Now in the Database connection string use the user name as the var in
Cookie and password same so it would be like
pg_connect(blah , blah user name=$COOKIE_VAR_USERNAME , password
=$COOKIE_VAR_PASSWORD)
Benefits
1. You will be able to use current_user() function
2. No user management system required PostgreSQL user is ur web user
3. PostgreSQL group will define levels

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

I doubt but you may see
contrib/database_size function

If this helps then pass on the word "PostgreSQL is Walah !" and kindly
shoot back

Regards,
V Kashyap