How to grant FileIOPermission to assembly running under SQL Server ?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Oleg Subachev
    #1

    How to grant FileIOPermission to assembly running under SQL Server ?

    I try to write some info to file in the CLR Trigger under SQL Server 2005.

    But I get the following error:
    System.Security .SecurityExcept ion: Request for the permission of type
    'System.Securit y.Permissions.F ileIOPermission , mscorlib, Version=2.0.0.0 ,
    Culture=neutral , PublicKeyToken= b77a5c561934e08 9' failed.

    How can I grant FileIOPermissio n to my assembly running under SQL Server ?

    Oleg Subachev


    Tags: None
    • Alberto Poblacion
      #2
      Re: How to grant FileIOPermissio n to assembly running under SQL Server ?

      "Oleg Subachev" <oleg@urvb.ruwr ote in message
      news:urg5sxyQJH A.1144@TK2MSFTN GP05.phx.gbl...
      >I try to write some info to file in the CLR Trigger under SQL Server 2005.
      >
      But I get the following error:
      System.Security .SecurityExcept ion: Request for the permission of type
      'System.Securit y.Permissions.F ileIOPermission , mscorlib, Version=2.0.0.0 ,
      Culture=neutral , PublicKeyToken= b77a5c561934e08 9' failed.
      >
      How can I grant FileIOPermissio n to my assembly running under SQL Server ?
      When installing the assembly into the server (with CREATE ASSEMBLY...),
      add the clause "...WITH PERMISSION_SET= EXTERNAL ACCESS".


        Comment

        Previous template Next
        Working...