Hi, This time the command GRANT ALL PRIVILEGES ON DATABASE "casDatabase" to tester; did not give error.
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 Regards, Kakoli > -----Original Message----- > From: A. Kretschmer [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 13, 2008 3:22 PM > To: pgsql-general@postgresql.org > Subject: Re: Problem with GRANT in 7.4.19 > > > am Thu, dem 13.03.2008, um 15:09:18 +0530 mailte Kakoli Sen folgendes: > > Dear all, > > The command GRANT ALL PRIVILEGES ON DATABASE casDatabase to tester; > > is giving error: > > ERROR: database "casdatabase" does not exist.(Note that the db > name in error > > is all in lower case). > > > > Also \l shows that casDatabase exists. > > Why is 'casDatabase' being changed to 'casdatabase'? > > Try: > GRANT ALL PRIVILEGES ON DATABASE "casDatabase" to tester; > > > Andreas > -- > Andreas Kretschmer > Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) > GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
