none
update model from database import selected stored procedure disabled

    Question

  • entity framework update model from database import selected stored procedure disabled

    I added a view and I want to update the model in visual studio.  My co-worker can do it.  For me the link is gray, or disabled.  I started my visual studio project as administrator.  I checked the database, and it says that the administrator is a user.  I suspect this is a security issue, but I don't know how to solve it.  Thanks.

    Wednesday, August 27, 2014 12:31 PM

Answers

  • Hello JennyMQuinn,

    Please check if the db user has execute permissions on stored procedure, for example, if it is public role, it even cannot select tables although there are tables in database. Please connect with your DBA and ask him to give you the higher permission like sysadmin.

    Best Regards,

    Fred.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, August 28, 2014 3:37 AM
    Moderator