RE: Access Control in PostGreSQL

Have you tried this:
As data base superuser, GRANT INSERT ON <table> TO <user>;

jeff

-----Original Message-----
From: vijayendra mohan agrawal [mailto:vijayendra(dot)agrawal(at)wipro(dot)com]
Sent: Thursday, April 12, 2001 3:01 AM
To: PostGre SQL Mailing List
Subject: Access Control in PostGreSQL

Hi,

From my UNIX login, which is a valid user for the database too, I
connect to
database. I don't have permission to add, delete, view system tables
till
now.

Now, if I use the command "CONNECT" as user "pgadmin", which is
administrator of the database, the connect succeeds, and now, I am able
to
do anything in the system files too.

I guess this is not intentional. I might be missing something. Please
help.

Thanks and Regards
Vijay