diff options
author | Robert Haas <rhaas@postgresql.org> | 2013-03-27 08:10:14 -0400 |
---|---|---|
committer | Robert Haas <rhaas@postgresql.org> | 2013-03-27 08:14:19 -0400 |
commit | 1cea9bbb21e9e90dc7085ce605d9160e7161fa58 (patch) | |
tree | 509f427c60f54bf16b8b419ab80833341e8abfab /doc/src | |
parent | bc5334d8679c428a709d150666b288171795bd76 (diff) | |
download | postgresql-1cea9bbb21e9e90dc7085ce605d9160e7161fa58.tar.gz postgresql-1cea9bbb21e9e90dc7085ce605d9160e7161fa58.zip |
sepgsql: Support for new post-ALTER access hook.
KaiGai Kohei
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/sepgsql.sgml | 22 |
1 files changed, 19 insertions, 3 deletions
diff --git a/doc/src/sgml/sepgsql.sgml b/doc/src/sgml/sepgsql.sgml index e7ce8b5d5b3..5ee08e1dee2 100644 --- a/doc/src/sgml/sepgsql.sgml +++ b/doc/src/sgml/sepgsql.sgml @@ -438,6 +438,12 @@ UPDATE t1 SET x = 2, y = md5sum(y) WHERE z = 100; On creation of objects within a particular schema (tables, views, sequences and procedures), <literal>add_name</> will be also checked on the schema, not only <literal>create</> on the new object itself. + On <xref linkend="sql-createfunction">, <literal>install</> permission + will be checked if <literal>leakproof</> attribute was given, not only + <literal>create</> on the new function. This permission will be also + checked when user tries to turn on <literal>leakproof</> attribute + using <xref linkend="sql-alterfunction"> command, with + <literal>setattr</> permission on the function being altered. </para> <para> @@ -450,9 +456,19 @@ UPDATE t1 SET x = 2, y = md5sum(y) WHERE z = 100; </para> <para> - When objects that are subsidiary of other objects (such as a table's indexes - or triggers) are created or dropped, <literal>setattr</> permission will be - checked on the main object, instead of the subsidiary object itself. + When <literal>ALTER</> command is executed, <literal>setattr</> will be + checked on the object being modified for each object types. + In addition, <literal>remove_name</> and <literal>add_name</> + will be checked on the old and new schemas, respectively, when an + object is moved to a new schema. + For certain object types, additional checks are performed. + </para> + + <para> + When objects that are subsidiary of other objects (such as a table's + indexes or triggers) are created, dropped or altered, + <literal>setattr</> permission will be checked on the main object, + instead of the subsidiary object itself. </para> <para> |