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. The

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 casDataba

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 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 change

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 sho

[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'? Reg