Re: control privilege for view function source code
By default, SYSCAT views are SELECTable by PUBLIC ..
So revoke the privilege using
REVOKE SELECT ON SYSCAT.<viewname> from PUBLIC
You have to issue one statement per view ..
Then grant the privilege to the particular user you are interested in :
GRANT SELECT ON SYSCAT.<tabname> to USER <username>
Originally posted by guyang2000
I create a function, eg. called schema.function(par char(10)).
but seems every user have the right to check the syscat.functions system catalog and view the function source code.
Is there any way to control privilege for view the function source code.
That only the function owner have full privilege, but other user can't see the source code.
Thanks in advance.
Visit the new-look IDUG Website , register to gain access to the excellent content.