sql server - Error genereating publish script: the select permission was denied on the object __refactorlog? -

in ssdt project, why getting error?

"the select permission denied on object __refactorlog?"

there refactorlog item in project.

i select generate publish script inside vs.

edit: target production server, don't have permissions create tables or select data there, have create deployment script, , there no table __refactorlog anyway..

you need greater permissions have on server in order generate publish script. verified there call "select object_id(n'dbo.__refactorlog')" in code handling refactor operations checks if table exists. it's code failing @ point don't have permissions ask select object. can check running query against database , seeing if error.

suggestions determining permissions need:

• try right-clicking on database , choosing "create new project". if can't extract database definition project it's clear sign don't have view definition privileges on database
• if that's not case, issue need read permissions on __refactorlog table , don't have it. solution access table, or else you'd have verify none of refactorings needed , delete refactorlog project (not recommended want preserver refactorings avoid possible data loss , other issues).