Post reply

Diffrentiating scalar and table value functions

  • July 7, 2010 at 7:36 pm

    #234885

    I have a requirement to grant permissions on database objects to roles and users.

    As per my understanding we have to "grant execute" permission to table value functions and "grant select" on scalar functions and procedures.

    How can these two types of functions be differentiated through program or by query?

  • July 7, 2010 at 7:47 pm

    #1189957

    select name

    from sys.objects

    where type IN ('IF', -- SQL_INLINE_TABLE_VALUED_FUNCTION

    'TF', -- SQL_TABLE_VALUED_FUNCTION

    'FN') -- SQL_SCALAR_FUNCTION

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

Viewing 2 posts - 1 through 2 (of 2 total)

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