In this blog post, let’s learn about the error message “21682 – Cannot publish table [%s].[%s]. The replication administraive user requires an explicit SELECT grant, or a SELECT grant through PUBLIC, in order to publish this table. A role-based SELECT grant, if one exists, is not sufficient.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
21682 – Cannot publish table [%s].[%s]. The replication administraive user requires an explicit SELECT grant, or a SELECT grant through PUBLIC, in order to publish this table. A role-based SELECT grant, if one exists, is not sufficient.
Reason for the Error
To be update soon…
Solution
To be update soon…