Erro ao acessar Oracle - WebService

[Aislan Miranda]

Pessoal, Boa Noite!

Estou com um probleminha ao acessar o banco Oracle por um WebService, o meu cenário é uma aplicação windows form que se comunica com WebService e o mesmo acessa o oracle, faz um select e retorna com os dados. Ele está apresentado a seguinte mensagem:

Em minhas pesquisa em busca da solução, li algumas pessoas comentando para fazer um procedimento no web.config do Trust Level Customizado , mas não sei como configurar o mesmo no web.config. ALGUÉM JÁ PASSOU POR ISSO??

An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in System.Web.Services.dll

Additional information: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Security.SecurityException: Request for the permission of type 'System.Data.OracleClient.OraclePermission, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

   at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)

   at System.Security.PermissionSet.Demand()

   at System.Data.Common.DbConnectionOptions.DemandPermission()

   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.OracleClient.OracleConnection.Open()

   at EasyDBAccess.Connection.Open()

   at ContractService.GetTradingBookReport(String company, String FilterResult)

The action that failed was:

Demand

The type of the first permission that failed was: System.Data.OracleClient.OraclePermission

The first permission that failed was:

<IPermission class="System.Data.OracleClient.OraclePermission, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

AllowBlankPassword="False">

<add ConnectionString="Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED)  (SERVICE_NAME = service_name)));Integrated Security=False;User ID=ID;password=*;"

KeyRestrictions=""

KeyRestrictionBehavior="AllowOnly"/>

</IPermission>

The demand was for:

<PermissionSet class="System.Security.PermissionSet"

version="1">

<IPermission class="System.Data.OracleClient.OraclePermission, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

AllowBlankPassword="False">

<add ConnectionString="Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA =(SERVER = DEDICATED)  (SERVICE_NAME = service_name)));Integrated Security=False;User ID=*;password=*;"

KeyRestrictions=""

KeyRestrictionBehavior="AllowOnly"/>

</IPermission>

</PermissionSet>

The granted set of the failing assembly was:

<PermissionSet class="System.Security.PermissionSet"

version="1">

<IPermission class="System.Security.Permissions.FileDialogPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Access="Open"/>

<IPermission class="System.Security.Permissions.IsolatedStorageFilePermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Allowed="ApplicationIsolationByUser"

UserQuota="512000"/>

<IPermission class="System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Flags="Execution"/>

<IPermission class="System.Security.Permissions.UIPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Window="SafeTopLevelWindows"

Clipboard="OwnClipboard"/>

<IPermission class="System.Security.Permissions.StrongNameIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

PublicKeyBlob="00240000048000009400000006020000002400005253413100040000010001008B0F78D9ABF0F7E6CAC7FF5A75D092FC24D05771D4E37FD2C31674893145E3EBC8F23F1B3D4B525DB7B81EFA0D647EC8EC08F7CCFDF20A59DEE7FE0F1DB8BE460AF4D926E8A2D9620B111B668B93DB5478FD6EBE84EA1F6C12AB78414E0CEFA80D4C80F6BE46CCCD49938D2CC0F3EADCA6498EEA5820AE92BDB2C37C820966D1"

Name="EasyDBAccess"

AssemblyVersion="0.1.0.16704"/>

<IPermission class="System.Security.Permissions.UrlIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Url="file:///F:/Web/pasta_virtual/bin/EasyDBAccess.DLL"/>

<IPermission class="System.Security.Permissions.ZoneIdentityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

version="1"

Zone="Internet"/>

<IPermission class="System.Drawing.Printing.PrintingPermission, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

version="1"

Level="SafePrinting"/>

</PermissionSet>

The assembly or AppDomain that failed was:

EasyDBAccess, Version=0.1.0.16704, Culture=neutral, PublicKeyToken=94f3f3ff2d3e3c56

The method that caused the failure was:

Boolean Open()

The Zone of the assembly that failed was:

Internet

The Url of the assembly that failed was:

file:///F:/Web/pasta_virtual/bin/EasyDBAccess.DLL

   --- End of inner exception stack trace ---

Aislan Miranda
(27) 9-9880-8344

[Aislan Miranda]

Observação: quando eu rodo o código localmente webservice e o windows forms application, funfa 100%. Quando eu coloco o código no IIS, apresenta o erro informado anteriormente.

Aislan Miranda
(27) 9-9880-8344