Module Signing, signature, certificate, asymmetric key, SQL Server, T-SQL, TSQL, SQLCLR, SQL# 2020-9-30 17-52
         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. Set TRUSTWORTHY On smacks down service broker from working
  24. Can't use msdb.dbo.sp_send_dbmail when in service broker - executes as guest?
  25. Permissions not allowing Update or Select on a trigger executed function
  26. Server role with permission to create server login
  27. Grant a database role in current database with permission to execute a SP in msdb
  28. How do I create databases / logins / users with minimal privileges when installing an application?
  29. What minimum permissions and/or roles must a SQL Server login possess to be able to grant database db_datareader role to other logins?
  30. Access view based on table in another database without account in that other database
  31. Cross-database view - Not able to access database under the current security context
  32. SQL Permission to Truncate Table
  33. SQL Server impersonation
  34. Start job from another SQL server instance
  35. Execute Permissions for a Store Procedure that creates databases
  36. What permissions are required for UPDATE STATISTICS #table WITH ROWCOUNT = xxx?
  37. How to grant execute permissions to a stored procedure but not the underlying databases
  38. Grant permissions on a stored procedure to tables in another schema
  39. How to maintain database ownership restoring across domains?
  40. Security and Performance implications of “View Server State”
  41. Granting a user a permission to restore a database


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 (Msg 10314)
  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
  10. Can a Certificate’s Private Key be Imported / Restored From a Binary Literal / Hex Bytes ?

Module Signing, SQL Server, certificate, signature, certificate, asymmetric key, T-SQL, TSQL, SQLCLR, SQL# 2020-9-30 17-52