Permissions

SQL Server security will refuse permission to users to execute any of the DML statements (INSERT, DELETE, UPDATE, and SELECT) on a table or view, so you have to explicitly enable the access. Members of the sysadmin fixed server roles, the db_owner user, and the db_datawriter fixed database roles automatically have permission. Members of sysadmin, db_owner, and db_securityadmin can permit other users to run these statements (see Chapter 5).