[GENERAL] Strange behavior of "grant temp on schema"

xt as $$ 46 begin 47 return user; 48 end 49 $$ language plpgsql volatile security definer; 50 51 commi -- Regards, Andrew G. Saushkin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Strange behavior of "grant temp on schema"

I apologize for my carelessness. Error rollback code including all completed "revoke". Therefore, users can create functions. If you add another commit before "grant temp on schema public to sec_privilege;" it will be seen that create a function is also not possible. 14 15 create database

[GENERAL] Qury plan for sql function with security definer

version │ ├──┤ │ PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit │ └───────────