July 16, 2018 at 10:34 am
Symmetric Keys and CF.
Running into the : Cannot find the symmetric key 'xxx', because it does not exist or you do not have permission.
I have checked permissions for the user (CF). I can run the stored procedure perfectly in SQL Server under the same user, and in CF it runs, but CF can't find the key.
Any ideas?
July 16, 2018 at 10:48 am
danfarmer1973 - Monday, July 16, 2018 10:34 AMSymmetric Keys and CF.Running into the : Cannot find the symmetric key 'xxx', because it does not exist or you do not have permission.
I have checked permissions for the user (CF). I can run the stored procedure perfectly in SQL Server under the same user, and in CF it runs, but CF can't find the key.
Any ideas?
See the possible permissions here: https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-certificate-permissions-transact-sql?view=sql-server-2017
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
July 16, 2018 at 10:55 am
sgmunson - Monday, July 16, 2018 10:48 AMdanfarmer1973 - Monday, July 16, 2018 10:34 AMSymmetric Keys and CF.Running into the : Cannot find the symmetric key 'xxx', because it does not exist or you do not have permission.
I have checked permissions for the user (CF). I can run the stored procedure perfectly in SQL Server under the same user, and in CF it runs, but CF can't find the key.
Any ideas?
See the possible permissions here: https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-certificate-permissions-transact-sql?view=sql-server-2017
Yeah, I did all that.
Perhaps I should mention that the Procedure is in the master db.
July 16, 2018 at 11:07 am
I did the following regarding permissions....
CONTROL ON CERTIFICATE :: xxx TO [xxx]
GO
GRANT VIEW DEFINITION ON CERTIFICATE:: xxx TO [xxx]
GO
GRANT REFERENCES ON CERTIFICATE:: xxx TO [xxx]
GO
GRANT TAKE OWNERSHIP ON CERTIFICATE:: xxx TO [xxx]
GO
GRANT CONTROL ON SYMMETRIC KEY:: xxx TO [xxx]
GO
GRANT VIEW DEFINITION ON SYMMETRIC KEY:: xxx TO [xxx]
GO
GRANT REFERENCES ON SYMMETRIC KEY:: xxx TO [xxx]
GO
GRANT TAKE OWNERSHIP ON SYMMETRIC KEY :: xxx TO [xxx]
GO
July 17, 2018 at 7:30 am
For anyone needing assistance on this I was able to make this work by use of the USE [database]; command in a <CFQUERY> calling the stored procedure.
The granting commands didn't seem to help.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply