Thread: 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

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

jeff


-----Original Message-----
From: vijayendra mohan agrawal [mailto:vijayendra.agrawal@wipro.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