Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Permissions to execute Assemblies... Expand / Collapse
Author
Message
Posted Friday, February 15, 2008 9:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 4:53 AM
Points: 186, Visits: 818
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 ;)
Post #456378
Posted Friday, February 15, 2008 1:10 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:41 AM
Points: 1,147, Visits: 1,942
USE [database] GRANT EXECUTE ON ASSEMBLY::[assemblyname] TO [USER];

---
SQLSlayer
Making SQL do what we want it to do.

Post #456500
Posted Saturday, February 16, 2008 4:25 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 12:34 PM
Points: 1,865, Visits: 3,615
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


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #456617
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse