Hi,
How do I grant all on database TO PUBLIC?
Without having to go through each table in that database?
Basically I have created a databases as one user, and I want another
user
to be able to access all tables in that database. However
when i run simple query like "SELECT * from tablename" as that "other
user"
it gives me (ERROR: tablename: Permission denied).
GRANT doesnt let you grant access to the entire databases , only tables.
and since I have over 30 tables in my DB goin through each table and
setting
permissions by hand is too time consuming.
Regards,
Boulat.
--
Nothing Like the Sun