Additional SQL Server features and topics not covered by specific categories
What is the minimum level of permission that is required to effectively determine if an object is signed using sys.crypt_properties?
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
1 answer
Sort by: Oldest
-
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