mssql user permission

fixed database role

 

db_datareader            # can run a SELECT statement against any table or view in the database.

db_ddladmin              # can run any Data Definition Language (DDL) command in a database.

* only members of the db_owner database role can add members to the db_owner
 * Every database user belongs to the public database role.
 (When a user has not been granted or denied specific permissions on a securable, the user inherits the permissions granted to public on that securable. )

sysadmin

These users can monitor replication and have full control over changing replication properties such as agent schedules, agent profiles, and so on.

replmonitor(in the distribution database)

These users can monitor replication, but cannot change any replication properties.

 


 

Creative Commons license icon Creative Commons license icon