August 12th, 2002, 05:41 AM
Tables of another user also visible ??
I just created one user (user1), then logged in as user1 and created some tables as user1 in PostgreSQL.
I then created another user(user2), now when I give \d, I'm able to see the tables created by user1.
Is this normal functionality ? or am I missing something ??
Of course, I'm unable to do a select on user1's tables... it gives me ... Permission denied.
Is there an option, so that user1's tables are not visible to user2 ??
I'm new to PostgreSQL. Any pointers ??
Thanks & Regards.