Post reply

scalared valued functions

  • June 8, 2010 at 10:51 am

    #223566

    Hi,

    I got read access to a database named xyz.

    the owner of the database created some scalared valued functions. But now i'm unable use that functions and i cant even see that functions. So my question is

    can a user with read access to a database use scalar valued functions created.

  • June 8, 2010 at 11:07 am

    #1177595

    a user would need EXECUTE permissions on the functions in order to use them.. read(SELECT) access, like granting db_datareader, is limited to tables or views.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 8, 2010 at 11:41 am

    #1177617

    @lowell

    Thanq so much

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

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