Post reply

UDF Permissions Disappear on Edit

  • May 20, 2005 at 2:11 pm

    #89013

    We are running SQL Server 2000, Standard Edition, SP3. I use a lot of UDF's and I have never seen this one before. I have a very large multistatement table-valued function. When I edit and save (just adding one blank line, for example), the Select permission of this object for a user role disappears!

    I have added a comment at the top of the function to remind me to reset permissions after editing, but I have never had to do anything like that before.

    Any clues as to what is going on?

    Thanks,

    JFW

     

  • May 21, 2005 at 12:53 am

    #560380

    You must be dropping the UDF and recreating it.

    Kindest Regards,

    Amit Lohia

  • May 21, 2005 at 6:59 am

    #560386

    Amit,

    I think you are right, but I am not dropping it, Enterprise Manager is dropping it. I wonder why it decided to drop and recreate this particlar function and not the multitude of other functions I work with every day? The main difference is the size. Perhaps I have reached a threshold that forces this action.

     

    JFW

     

  • May 21, 2005 at 10:13 am

    #560389

    Can you post the UDF ?

     

    Kindest Regards,

    Amit Lohia

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

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