Module Signing, signature, certificate, asymmetric key, SQL Server, T-SQL, TSQL, SQLCLR, SQL# 2019-5-24 7-9
         Module Signing Info
     Home       Concepts       Answers       Reference       Microsoft Connect       Contact 
Module Signing, signature, certificate, asymmetric key, SQL Server, T-SQL, TSQL, SQLCLR, SQL#
DBA.StackExchange
  1. Issues with module signing and SSIS catalog internal procedures
  2. SQL Server Chain Permission
  3. What minimum permissions do I need to provide to a user so that it can check the status of SQL Server Agent Service?
  4. Role to view SQL server job log
  5. Is it possible to add a certificate to a database role?
  6. Assigning permissions for sysmail_update_account_sp
  7. SSDT Schema Comparison for Stored Procedure signed by a Certificate
  8. Find signed procedures, functions, triggers, assemblies and by which certificates / asymmetric keys
  9. stored procedure can select and update tables in other databases - minimal permissions granted
  10. Is there a way in SQL Server to make a table only able to insert by trigger?
  11. Use of IMPERSONATE permissions in SQL Server?
  12. Creating a helper UDF or stored procedure and limiting external access
  13. Why isn't the ASYMKEY_ID function returning the Asymmetric Key ID?
  14. Stored procedure security with execute as, cross database queries, and module signing
  15. Impersonate user or login mapped to certificate
  16. Is there a way to give GRANT OPTION recursively for subsets of permissions?
  17. SQL Server Impersonation is just NOT working
  18. How to tell if Database Certificate Used?
  19. Giving Special Permissions to a Stored Procedure in SQL Server
  20. How do I check that the database master key encryption is valid?
  21. DB Master Key Encrypted By *Correct* Service Master Key?
  22. Permissions in triggers when using cross database certificates
  23. Can't use msdb.dbo.sp_send_dbmail when in service broker - executes as guest?
  24. Permissions not allowing Update or Select on a trigger executed function
  25. Server role with permission to create server login
  26. Grant a database role in current database with permission to execute a SP in msdb
  27. How do I create databases / logins / users with minimal privileges when installing an application?
  28. What minimum permissions and/or roles must a SQL Server login possess to be able to grant database db_datareader role to other logins?
  29. Access view based on table in another database without account in that other database
  30. Cross-database view - Not able to access database under the current security context
  31. SQL Permission to Truncate Table
  32. SQL Server impersonation
  33. Start job from another SQL server instance


Blog Posts
  1. SQLCLR vs. SQL Server 2017, Part 1: “CLR strict security” – The Problem
  2. SQLCLR vs. SQL Server 2017, Part 2: “CLR strict security” – Solution 1
  3. SQLCLR vs. SQL Server 2017, Part 3: “CLR strict security” – Solution 2
  4. SQLCLR vs. SQL Server 2017, Part 4: “Trusted Assemblies” – The Disappointment
  5. SQLCLR vs. SQL Server 2017, Part 5: “Trusted Assemblies” – Valid Use Cases?
  6. SQLCLR vs. SQL Server 2017, Part 6: “Trusted Assemblies” – Whitelisted Assemblies can’t do Module Signing
  7. PLEASE, Please, please Stop Using Impersonation, TRUSTWORTHY, and Cross-DB Ownership Chaining
  8. Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Server-level
  9. Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Database-level
Module Signing, SQL Server, certificate, signature, certificate, asymmetric key, T-SQL, TSQL, SQLCLR, SQL# 2019-5-24 7-9