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

jeff


-----Original Message-----
From: vijayendra mohan agrawal [mailto:[EMAIL PROTECTED]]
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


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

Reply via email to