Using current_database() in a grant

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Using current_database() in a grant
Дата
Msg-id 20021020152715.GA15001@wolff.to
обсуждение исходный текст
Ответы Re: Using current_database() in a grant  (Bruno Wolff III <bruno@wolff.to>)
Re: Using current_database() in a grant  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
In 7.3b1 I am trying to use current_database in a grant statement to
give access to the current database in a script. Since I really
only have one database I plan on using the script for I can just
hard code the name. However I would think it would be nice to allow
this to work so people can keep their scripts more general without
having to do more complicated mechanisms.

Here is what happens when I try this:
area=# grant create on database current_database() to bruno;
ERROR:  parser: parse error at or near "(" at character 42

В списке pgsql-general по дате отправления:

Предыдущее
От: Markus Jais
Дата:
Сообщение: red hat graphical tools: rpms or tgz ??
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Using current_database() in a grant