July 10, 2008 at 10:15 am
Hi please can someone help with an explanation?
I amended a function today which was owned by dbo. I was logged on with dbo credentials and ran a simple alter script on the function to amend any objects specified simply as 'table' to 'schema.table' to ensure optimal performance. The update actioned fine, however when I tested it became apparent that any user/role permissions explicitly applied to the function were lost?
The problem was simply rectified by reallocating the required rights to the relevant roles, however I am confused as to why they were removed in the first place (it was an alter rather than a drop and create).
One thing to note though was that I am using SQL 2005 Studio Manager and the db is SQL2000.... does that automatically do a drop and create?
July 10, 2008 at 10:20 am
My guess is, your objects have different names after altering them from 'table' to 'schema.table' . You may have to grant permissions again.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply