ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to create a script to trust an assembly - Excel 2003 - Office System Project with C# (https://www.excelbanter.com/excel-programming/342004-how-create-script-trust-assembly-excel-2003-office-system-project-c.html)

John Yung

How to create a script to trust an assembly - Excel 2003 - Office System Project with C#
 
Hi,

In order to run Excel 2003 - Office System Project with C#. All assemblies
(.DLL) use by the project must be set to full trust.

To do it manually, you right click on .NET Configuration 1.1--Runtime
Security Policy and select "Trust an Assembly".

How can I automate this process?

Thanks,

John Yung



Jim Thomlinson[_4_]

How to create a script to trust an assembly - Excel 2003 - Office
 
Security policies and such (normally) can not be manipulted in code. If you
could then it would defeat the purpose of the security. A virus would just
change the settings and then do it's damage...
--
HTH...

Jim Thomlinson


"John Yung" wrote:

Hi,

In order to run Excel 2003 - Office System Project with C#. All assemblies
(.DLL) use by the project must be set to full trust.

To do it manually, you right click on .NET Configuration 1.1--Runtime
Security Policy and select "Trust an Assembly".

How can I automate this process?

Thanks,

John Yung




John Yung

How to create a script to trust an assembly - Excel 2003 - Office
 
Jim,



The ability to change security policy through code does not defeat the
purpose of the security policy. As long as I have the right to change the
policy, it does not matter how I does (via code or manual operation).



What do you think happens when I modify the policy manually? Behind the
screen, the policy is changed via code.


JY



"Jim Thomlinson" wrote in message
...

Security policies and such (normally) can not be manipulted in code. If

you

could then it would defeat the purpose of the security. A virus would just


change the settings and then do it's damage...


--


HTH...




Jim Thomlinson






"John Yung" wrote:




Hi,




In order to run Excel 2003 - Office System Project with C#. All

assemblies

(.DLL) use by the project must be set to full trust.




To do it manually, you right click on .NET Configuration 1.1--Runtime


Security Policy and select "Trust an Assembly".




How can I automate this process?




Thanks,




John Yung










Jim Thomlinson[_4_]

How to create a script to trust an assembly - Excel 2003 - Off
 
When you change the policy manually you are giving your explicit approval to
change the settings on your machine. The point is that you physically had to
make the change and that is fair warning. If you can make the change through
code and avoid the interaction with the end user then you remove the element
of giving the end user fair warning that making a security change could have
consequences. You can not give consent to security policy changes through
code (normally). My question back to you is if code is allowed to manipulate
security settings then what is the point to the security settings? What
exactly are they protecting against?
--
HTH...

Jim Thomlinson


"John Yung" wrote:

Jim,



The ability to change security policy through code does not defeat the
purpose of the security policy. As long as I have the right to change the
policy, it does not matter how I does (via code or manual operation).



What do you think happens when I modify the policy manually? Behind the
screen, the policy is changed via code.


JY



"Jim Thomlinson" wrote in message
...

Security policies and such (normally) can not be manipulted in code. If

you

could then it would defeat the purpose of the security. A virus would just


change the settings and then do it's damage...


--


HTH...




Jim Thomlinson






"John Yung" wrote:




Hi,




In order to run Excel 2003 - Office System Project with C#. All

assemblies

(.DLL) use by the project must be set to full trust.




To do it manually, you right click on .NET Configuration 1.1--Runtime


Security Policy and select "Trust an Assembly".




How can I automate this process?




Thanks,




John Yung











Nick Hertl

How to create a script to trust an assembly - Excel 2003 - Off
 
Code Access Security is a concept too complicated to discuss in full
here, but I suggest that you get a book on it and read up.
For a quick answer to you question, take a look at the tool
"caspol.exe" that comes with visual studio. It alows you to modify
security policy on the command line.


Jim Thomlinson[_4_]

How to create a script to trust an assembly - Excel 2003 - Off
 
My answers here are all "To the best of my knowledge"... If I missed
something based on a limit there-in then... Sorry. Within the code itself I
was and still am unaware of how to go about making the switches to security
policy... I was under the impression they were blocked.
--
HTH...

Jim Thomlinson


"Nick Hertl" wrote:

Code Access Security is a concept too complicated to discuss in full
here, but I suggest that you get a book on it and read up.
For a quick answer to you question, take a look at the tool
"caspol.exe" that comes with visual studio. It alows you to modify
security policy on the command line.



Jim Thomlinson[_4_]

How to create a script to trust an assembly - Excel 2003 - Off
 
Just to clarify, by automate I was under the impression that John wanted a
custom code solution. I was unaware of CASPOL...
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

My answers here are all "To the best of my knowledge"... If I missed
something based on a limit there-in then... Sorry. Within the code itself I
was and still am unaware of how to go about making the switches to security
policy... I was under the impression they were blocked.
--
HTH...

Jim Thomlinson


"Nick Hertl" wrote:

Code Access Security is a concept too complicated to discuss in full
here, but I suggest that you get a book on it and read up.
For a quick answer to you question, take a look at the tool
"caspol.exe" that comes with visual studio. It alows you to modify
security policy on the command line.



John Yung

How to create a script to trust an assembly - Excel 2003 - Off
 
Security policy exists to prevent users from making unauthorized
changes/actions. Thus, if the policy says you have the permission to change
it. It does not matter if you are changing it via code or manual operation.

John Yung

"Jim Thomlinson" wrote in message
...
When you change the policy manually you are giving your explicit approval

to
change the settings on your machine. The point is that you physically had

to
make the change and that is fair warning. If you can make the change

through
code and avoid the interaction with the end user then you remove the

element
of giving the end user fair warning that making a security change could

have
consequences. You can not give consent to security policy changes through
code (normally). My question back to you is if code is allowed to

manipulate
security settings then what is the point to the security settings? What
exactly are they protecting against?
--
HTH...

Jim Thomlinson


"John Yung" wrote:

Jim,



The ability to change security policy through code does not defeat the
purpose of the security policy. As long as I have the right to change

the
policy, it does not matter how I does (via code or manual operation).



What do you think happens when I modify the policy manually? Behind the
screen, the policy is changed via code.


JY



"Jim Thomlinson" wrote in message
...

Security policies and such (normally) can not be manipulted in code.

If
you

could then it would defeat the purpose of the security. A virus would

just

change the settings and then do it's damage...


--


HTH...




Jim Thomlinson






"John Yung" wrote:




Hi,




In order to run Excel 2003 - Office System Project with C#. All

assemblies

(.DLL) use by the project must be set to full trust.




To do it manually, you right click on .NET Configuration

1.1--Runtime

Security Policy and select "Trust an Assembly".




How can I automate this process?




Thanks,




John Yung













John Yung

How to create a script to trust an assembly - Excel 2003 - Off
 
Actually, I had found the solution (ex: caspol.exe -pp off -af foo.dll would
grant foo.dll full trust) yesterday. But, thanks Nick.

John Yung

"John Yung" wrote in message
...
Security policy exists to prevent users from making unauthorized
changes/actions. Thus, if the policy says you have the permission to

change
it. It does not matter if you are changing it via code or manual

operation.

John Yung

"Jim Thomlinson" wrote in message
...
When you change the policy manually you are giving your explicit

approval
to
change the settings on your machine. The point is that you physically

had
to
make the change and that is fair warning. If you can make the change

through
code and avoid the interaction with the end user then you remove the

element
of giving the end user fair warning that making a security change could

have
consequences. You can not give consent to security policy changes

through
code (normally). My question back to you is if code is allowed to

manipulate
security settings then what is the point to the security settings? What
exactly are they protecting against?
--
HTH...

Jim Thomlinson


"John Yung" wrote:

Jim,



The ability to change security policy through code does not defeat the
purpose of the security policy. As long as I have the right to change

the
policy, it does not matter how I does (via code or manual operation).



What do you think happens when I modify the policy manually? Behind

the
screen, the policy is changed via code.


JY



"Jim Thomlinson" wrote in message
...

Security policies and such (normally) can not be manipulted in code.

If
you

could then it would defeat the purpose of the security. A virus

would
just

change the settings and then do it's damage...

--

HTH...



Jim Thomlinson





"John Yung" wrote:



Hi,



In order to run Excel 2003 - Office System Project with C#. All
assemblies

(.DLL) use by the project must be set to full trust.



To do it manually, you right click on .NET Configuration

1.1--Runtime

Security Policy and select "Trust an Assembly".



How can I automate this process?



Thanks,



John Yung















All times are GMT +1. The time now is 08:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com