The easiest way to be able to create an assembly as UNSAFE/EXTERNAL ACCESS

by admin 23. June 2008 11:45

The easiest way to be able to create an assembly as UNSAFE/EXTERNAL ACCESS you can do this:

1. Mark the database as trustworthy: ALTER DATABASE db_name SET TRUSTWORTHY ON 
2. Give the login of the owner of the database the right permissions: GRANT EXTERNAL ACCESS ASSEMBLY to userlogin.

That's it. You can now create an assembly as EXTERNAL ACCESS/UNSAFE. 

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Security | SQL 2005

Comments are closed

Powered by BlogEngine.NET 1.4.5.0
Theme by Mads Kristensen

Calendar

<<  March 2010  >>
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234

View posts in large calendar