Msg 15151 Cannot find the certificate
来源:互联网 发布:冈仁波齐神秘事件知乎 编辑:程序博客网 时间:2024/05/22 10:56
早上执行加密的存储过程出现下面的错误:
Msg 15151, Level 16, State 1, Line 23
Cannot find the certificate 'EncryptCert', because it does not exist or you donot have permission.
查了一下发现访问的账户只是赋予了执行存储过程的权限,如果不是用加密是没有问题。网上查了一下,需要对证书和Key单独加权限.
代码如下:
--需要对证书有Control权限
GRANT CONTROLON CERTIFICATE::EncryptCertTOUser1;
GO
--对Key需要REFERENCES权限
GRANT REFERENCESON SYMMETRIC KEY::PoolKey TO User1;
GO
执行上面的代码问题解决。
- Msg 15151 Cannot find the certificate
- Unable to find manifest signing certificate in the certificate store.
- Unable to find manifest signing certificate in the certificate store
- 错误"Unable to find manifest signing certificate in the certificat...
- 错误"Unable to find manifest signing certificate in the certificat...
- 错误"Unable to find manifest signing certificate in the certificat...
- 错误 "Unable to find manifest signing certificate in the certificat"
- html:messages 老出现 Cannot find bean: "msg " in any scope
- Error: Unable to find manifest signing certificate in the certificate store
- 解决:Unable to find manifest signing certificate in the certificate store
- C#:Unable to find manifest signing certificate in the certificate store
- error MSB3323: Unable to find manifest signing certificate in the certificate st
- vs2008工程拷贝新机器编译Unable to find manifest signing certificate in the certificate store
- 错误"Unable to find manifest signing certificate in the certificate store"的解决方法
- C#_错误"Unable to find manifest signing certificate in the certificate store"
- Msg 15138 The database principal owns a schema in the database, and cannot be dropped.
- Cannot find the insert section “AFX_MSG_MAP”
- SP2-0618: Cannot find the Session Identifier
- jQuery中使用Ajax获取JSON格式数据
- JS事件冒泡详解
- java zxing 生成带图片的二维码
- 三星推出跨界手机产品Galaxy S II TV:可当做电视机使用
- c3p0三种配置方式
- Msg 15151 Cannot find the certificate
- Arraylist LinkedList 区别 (读 <Java性能优化> 之List接口笔记 )
- java 代理机制
- 初遇ASCLL码
- iOS App各种图片尺寸(视网膜屏)
- 关于Linux的版本问题
- 关于方法的重写(基础篇)
- 像程序员一样思考
- Linux防火墙详解