没有查询、插入、更新、删除权限

2024-05-08 15:22:23

报错原文

cmdTransaction:The INSERT permission was denied on the object 'tb_Vendor_CocImgs', database 'QSIDB', schema 'dbo'.
The INSERT permission was denied on the object 'tb_Vendor_CocImgs', database 'QSIDB', schema 'dbo'.

报错原因

登录账户没有执行INSERT语句的权限

解决方案

--使用DBA账号登录
USE database_name;
GRANT SELECT ON 表名 TO user_name;
GRANT INSERT ON 表名 TO user_name;
GRANT UPDATE ON 表名 TO user_name;
GRANT DELETE ON 表名 TO user_name;