What is the minimum level of permission that is required to effectively determine if an object is signed using sys.crypt_properties?

DanielAdeniji 21 Reputation points
2024-04-01T13:52:28.3633333+00:00

I am signing stored procedures using certificates.

Inside the stored procedure what is the minimum requirement needed to determine whether the the running module is signed.

If not signed, I would like to quickly show an error message and exit the module or SP.

The same question asked a different way:-

execute as user='lowprivilege'

select *

from sys.crypt_properties

revert;

will return an empty record set for a low privilege user;

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

1 answer

Sort by: Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    1 deleted comment

    Comments have been turned off. Learn more

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.