Doing this...

GRANT view definition ON SYMMETRIC KEY::[BTS_Key1] TO [johnm]

grant control on certificate::BTS_CERT1 to johnm

And removing the schema seems to be the key.

OPEN SYMMETRIC KEY [BTS_Key1]

DECRYPTION BY CERTIFICATE [BTS_CERT1];

Troy.

#

Any resolve to this... I'm having the same issue.

This grant succeeds...

GRANT alter,control,references,take ownership, view definition ON SYMMETRIC KEY::[BTS_Key1] TO [johnm]

GO

grant alter,control,references,take ownership, view definition on certificate::BTS_CERT1 to johnm;

GO

When johnm does...