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:andreas.kretschmer@schollglas.com]
> 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.
