am Thu, dem 13.03.2008, um 16:22:28 +0530 mailte Kakoli Sen folgendes: > Hi, > > This time the command GRANT ALL PRIVILEGES ON DATABASE "casDatabase" to > tester; did not give error. Okay. > > But the permission is still not there. I run the following commands : > > psql -d casDatabase -U tester -W. Then \z command shows empty Access Privileges > on all tables. > > Also select * from table_name; gives error : > > ERROR: permission denied for relation table_name Sure. A database != table. You have to grant access to the table. If you have many tables: 12:44 < akretschmer> ??grantall 12:44 < rtfm_please> For information about grantall 12:44 < rtfm_please> see http://pgedit.com/public/sql/acl_admin/index.html 12:44 < rtfm_please> or http://unf.be/postgresql/postgres_grant_all.perl 12:44 < rtfm_please> or http://www.archonet.com/pgdocs/grant-all.html I suggest the last link. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
