Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    55

    Unanswered: control privilege for view function source code

    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.

    Guyang

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    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.

    Guyang
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •