Wanted: Trick for granting permissions to users with hyphens
От | Herbert Liechti |
---|---|
Тема | Wanted: Trick for granting permissions to users with hyphens |
Дата | |
Msg-id | Pine.LNX.4.33.0311191641180.29660-100000@standbyme.thinx.ch обсуждение исходный текст |
Ответы |
Re: Wanted: Trick for granting permissions to users with hyphens
Re: Wanted: Trick for granting permissions to users with hyphens |
Список | pgsql-general |
Hello I like to grant some permissions to the user www-data (default user for apache under debian) GRANT SELECT, UPDATE, INSERT, DELETE ON customer TO herbie, www-data; The statements throws the following error: ERROR: parser: parse error at or near "-" at character 64 Seems to me that hyphens are not allowed for user names. But a »createuser www-data« is working correct an I can access the database with that user. I tried to quote the www-data with 'www-data', www\-data with the same result. Any hints? I'm using 7.3.2 Thanks and best regards Herbie -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Herbert Liechti http://www.thinx.ch The content management company. Visit http://www.contentx.ch ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
В списке pgsql-general по дате отправления: