![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlserver
小咪蜂
这个作者很懒,什么都没留下…
展开
-
sqlserver 无法建立外键
The REFERENCES permission was denied on the object '', database '', schema 'dbo'.第一运行了命令:GRANT UPDATE,DELETE,INSERT,SELECT,CREATE PROCEDURE,EXECUTE,REFERENCES TO user发现还是不行,检查了好久,发现权限重叠了,在其他组里面也有这个用户,而这个组没有权限建外键的...原创 2020-06-26 21:55:13 · 730 阅读 · 0 评论 -
the seLECT permission was denied on the object types database mssqlsystemresource schema sys
the seLECT permission was denied on the object 'types', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229)exec sp_droprolemember 'db_denydatareader',[user]exec sp_droprolemember 'db_denydatawriter',[user]原创 2020-06-26 03:17:58 · 3151 阅读 · 0 评论