Permissions to execute Assemblies...

• JMSM

  SSCertifiable

  Points: 5440

  More actions

  February 15, 2008 at 9:34 am

  #179206

  Hello,

  Can anyone tell me what permissions should i give to one user to execute Assemblies? and what is exactly one assembly?

  Thanks and regards,

  JMSM 😉

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  February 15, 2008 at 1:10 pm

  #778998

  USE [database] GRANT EXECUTE ON ASSEMBLY::[assemblyname] TO ;

• Marios Philippopoulos

  SSC Guru

  Points: 57190

  More actions

  February 16, 2008 at 4:25 am

  #779091

  JMSM (2/15/2008)

  ---

  Hello,

  Can anyone tell me what permissions should i give to one user to execute Assemblies? and what is exactly one assembly?

  Thanks and regards,

  JMSM 😉

  An assembly is a unit of managed (.NET) code, packaged as a .dll or .exe file:

  http://msdn2.microsoft.com/en-us/library/ms131107.aspx

  See also "CLR Integration Security":

  http://msdn2.microsoft.com/en-us/library/ms131071.aspx

  __________________________________________________________________________________
  SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
  Persisting SQL Server Index-Usage Statistics with MERGE[/url]
  Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]