pg_dump and REVOKE on function
От | Rod Taylor |
---|---|
Тема | pg_dump and REVOKE on function |
Дата | |
Msg-id | 1060702128.83667.24.camel@jester обсуждение исходный текст |
Ответы |
Re: pg_dump and REVOKE on function
Re: pg_dump and REVOKE on function |
Список | pgsql-hackers |
Below is output from 7.3 pg_dump that is being loaded into 7.4 beta1. It would seem that revoking the permissions of the owner doesn't work out so well. r=# CREATE FUNCTION weekdate (date) RETURNS timestamp with time zone r-# AS ' r'# SELECT cast(to_date(''01 01 ''|| extract(''year'' FROM $1), ''DD MM YYYY'') + r'# (cast(extract(''week'' FROM $1) AS numeric) *7-8) * interval ''1 day'' as timestamp with time zone);' r-# LANGUAGE sql; CREATE FUNCTION r=# r=# r=# -- r=# -- TOC entry 752 (OID 18968885) r=# -- Name: weekdate (date); Type: ACL; Schema: public; Owner: rbt r=# -- r=# r=# REVOKE ALL ON FUNCTION weekdate (date) FROM PUBLIC; REVOKE r=# GRANT ALL ON FUNCTION weekdate (date) TO PUBLIC; GRANT r=# REVOKE ALL ON FUNCTION weekdate (date) FROM rbt; ERROR: dependent privileges exist HINT: Use CASCADE to revoke them too.
В списке pgsql-hackers по дате отправления: