没有查询、插入、更新、删除权限
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;