GRANT ALL ON TO GROUP failure
От | posting-list@MailAndNews.com (Jari Aalto) |
---|---|
Тема | GRANT ALL ON TO GROUP failure |
Дата | |
Msg-id | ofosxmg6.fsf@blue.sea.net обсуждение исходный текст |
Список | pgsql-sql |
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 to READER psql:pg-def-group-grant.sql:69: ERROR: non-existent group "reader" 01:-- Postgres create table rights 02:-- $Id: pg-def-group-grant.sql,v 1.1 2001/08/23 19:26:16 jaalto Exp $ 03:-- 04:-- 05:-- GRANT allows the creator of an object to give specific permissions to 06:-- all users (PUBLIC) or to a certain user or group. Users other than the 07:-- creator don't have any access permission unless the creator GRANTs 08:-- permissions, after the object is created. 09: 10:\echo Granting ALL to ROOT 11: 12:GRANT ALL ON 13: bonus 14: , custid 15: , customer 16: , dept 17: , dual 18: , dummy 19: , emp 20: , item 21: , ordid 22: , ordx 23: , price 24: , prodid 25: , product 26: , sales 27: , salgrade 28: TO GROUP root; 29: 30:\echo Granting ALL to USER 31: 32:GRANT ALL ON 33: bonus 34: , custid 35: , customer 36: , dept 37: , dual 38: , dummy 39: , emp 40: , item 41: , ordid 42: , ordx 43: , price 44: , prodid 45: , product 46: , sales 47: , salgrade 48: TO GROUP user; 49: 50: 51:\echo Granting SELECT to READER 52: 53:GRANT SELECT ON 54: bonus 55: , custid 56: , customer 57: , dept 58: , dual 59: , dummy 60: , emp 61: , item 62: , ordid 63: , ordx 64: , price 65: , prodid 66: , product 67: , sales 68: , salgrade 69: TO GROUP reader; 70: 71:-- End of file ---------- -- http://tiny-tools.sourceforge.net/ Swatch @time http://www.ryanthiessen.com/swatch/resources.htm Convert @time http://www.mir.com.my/iTime/itime.htm
В списке pgsql-sql по дате отправления: