SQL Server Error Msg 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 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…