Re: [GENERAL] Problem with GRANT in 7.4.19

2008-03-13 Thread A. Kretschmer
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

[GENERAL] Problem with GRANT in 7.4.19

2008-03-13 Thread Kakoli Sen
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'?

Re: [GENERAL] Problem with GRANT in 7.4.19

2008-03-13 Thread Albe Laurenz
Kakoli Sen wrote: 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

Re: [GENERAL] Problem with GRANT in 7.4.19

2008-03-13 Thread Kakoli Sen
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

Re: [GENERAL] Problem with GRANT in 7.4.19

2008-03-13 Thread A. Kretschmer
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

Re: [GENERAL] Problem with GRANT in 7.4.19

2008-03-13 Thread Dawid Kuroczko
On Thu, Mar 13, 2008 at 11:52 AM, Kakoli Sen [EMAIL PROTECTED] wrote: 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