Post reply

permissions on functions

  • November 22, 2006 at 3:41 am

    #62834

    How can i define the type of function?

    I try to write a script that grant permissions on all objects in database. There is a problem wih functions. I have to grant exec permission on scalar functions, and select permissions on table-values functions. So I need to know the type of the function.

    Thanks in advance.

  • November 22, 2006 at 3:54 am

    #673410

    Check out OBJECTPROPERTY in BOL.

    Rich

  • November 22, 2006 at 3:58 am

    #673411

    Hi,

    You should identify this using the system table sysobjects. There is a field against each object with name Xtype and Type.. Which have the values 'FN' and 'TF' against the function showing that it is a scalar or a table type...

    Cheers

    cheers

  • November 22, 2006 at 4:17 am

    #673413

    Thank you very much.

    The both answers are great.

    It helped me.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply