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@xxxxxxxxxxxxxx]
>
Sent: Thursday, March 13, 2008 3:22 PM
> To:
pgsql-general@xxxxxxxxxxxxxx
> 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.
