Re: [SQL] GRANT ALL ON TO GROUP failure

2001-09-04 Thread Henshall, Stuart - WCP
You need to user is a reserved word so you need to quote it (ie: "user" rather than user) whenever you reference it.Does group reader exist? If it does then it might be a case issue as presumably you must have quoted user user to create it which also preserves case, so if you did the same

[SQL] GRANT ALL ON TO GROUP failure

2001-09-03 Thread Jari Aalto
Can anyone suggest, what is wrong with the following sql file? SOmehow the semicolon causes error? Jari class=# \i pg-def-group-grant.sql Granting ALL to ROOT CHANGE Granting ALL to USER psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "user" Granting SELECT t

[SQL] GRANT ALL ON TO GROUP failure

2001-08-30 Thread Jari Aalto+usenet
[Please keep CC] Can anyone suggest, what is wrong with the following sql file? SOmehow the semicolon causes error? Jari class=# \i pg-def-group-grant.sql Granting ALL to ROOT CHANGE Granting ALL to USER psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "

Re: [SQL] GRANT ALL ON TO GROUP failure

2001-08-29 Thread Peter Eisentraut
Jari Aalto writes: > class=# \i pg-def-group-grant.sql > Granting ALL to ROOT > CHANGE > Granting ALL to USER > psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "user" You need to double quote "user". It's a reserved word. > Granting SELECT to READER > psql:pg-def-group-g

Re: [SQL] GRANT ALL ON TO GROUP failure

2001-08-29 Thread Oliver Elphick
Jari Aalto wrote: > >Can anyone suggest, what is wrong with the following >sql file? SOmehow the semicolon causes error? ... >Granting ALL to USER >psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "user >" ... >32:GRANT ALL ON >33: bonus >34: ,

[SQL] GRANT ALL ON TO GROUP failure

2001-08-29 Thread Jari Aalto
Can anyone suggest, what is wrong with the following sql file? SOmehow the semicolon causes error? Jari class=# \i pg-def-group-grant.sql Granting ALL to ROOT CHANGE Granting ALL to USER psql:pg-def-group-grant.sql:48: ERROR: parser: parse error at or near "user" Granting SELECT t