Re: Required permissions cannot be acquired?

From: Bradley Plett (plettb_at_hotmail.com)
Date: 09/03/04

  • Next message: charlie_at_nunya.com: "Re: HELP! CreateProcessWithLogonW issue" 
    Date: Thu, 02 Sep 2004 16:56:49 -0600

    Thanks for that prompt reply!

    It was a good idea, but sadly it didn't make any difference in my
    case. :-(

    I did find it somewhat interesting that the permissions on "C:\oracle"
    already included everyone, but the permissions weren't being inherited
    by "C:\oracle\ora92". I had only been checking on "C:\oracle", so I
    was hopeful when I discovered this. Still, when I opened up
    "C:\oracle\ora92" to everyone, and ensured that everyone definitely
    had access to read & execute
    "C:\oracle\ora92\bin\Oracle.DataAccess.dll", there was no change in
    the behavior of my app, even after a reboot.

    Brad.

    P.S. DBase III+?!?!? Well, it's great to hear from another old-timer
    like myself who actually remembers that! :-)

    On Thu, 2 Sep 2004 14:35:03 -0700, Popezilla
    <Popezilla@discussions.microsoft.com> wrote:

    >I have had a very similar problem and what I did to solve it was to add the
    >everyone group read/write access to this folder and all subfolders. This was
    >on my dev machine and so did not matter. I doubt you want to do this in
    >production.
    >
    >I tried to be more granular than the entire directory by downloading FileMon
    >from SysInternals and watching to see what directory the aspnet_wp process
    >attempted to access when it got an access denied error, but that didn't work
    >in all cases.
    >
    >There is a link -
    >
    >http://www.error-bank.com/microsoft.public.dotnet.framework.adonet/79112_Thread.aspx
    >
    >This thread will tell you the same thing. Look at the last message in the
    >thread.
    >
    >Hope this helps. If not, I feel we should all go back to DBase III+.
    >
    >
    >"Bradley Plett" wrote:
    >
    >> I've posted a similar question in the
    >> microsoft.public.sqlserver.reportingsvcs group, but I need to solve
    >> this and it is more of a .NET/permissions issue anyway. However, it
    >> is in the context of RS' forms authentication, which is making it more
    >> difficult for me to understand/debug.
    >>
    >> I have forms authentication in SQL RS working like a charm. (For more
    >> info, see
    >> http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp).
    >> However, I am now trying to do some authentication against an Oracle
    >> database. What's very strange is that as soon as I try to bind to
    >> Oracle's client (Oracle.DataAccess in, by default,
    >> C:\oracle\ora92\bin\Oracle.DataAccess.dll), I get
    >> "System.Security.Policy.PolicyException: Required permissions cannot
    >> be acquired." I've definitely narrowed it down to the Oracle binding,
    >> but can't figure out how to make it work. I've looked in "Microsoft
    >> ..NET Framework 1.1 Configuration" under "Runtime Security Policy" and
    >> did an "Evaluate Assembly", which returned "Unrestricted". I also
    >> tried editing rssrvpolicy.config (in "C:\Program Files\Microsoft SQL
    >> Server\MSSQL\Reporting Services\ReportServer\") to add a full trust
    >> for the Oracle.DataAccess.dll, but none of this has helped. Any other
    >> ideas or suggestions?
    >>
    >> Despite being much more capable, I often find .NET permissions much
    >> more confusing, especially trying to debug this type of failure. If
    >> anyone can point me to some good tools and/or techniques on this
    >> topic, I'd MUCH appreciate it. I suppose part of the problem is that
    >> I don't have time to read an entire book - I just want to skip to the
    >> good parts! :-)
    >>
    >> Thanks a lot!
    >> Brad.
    >>

  • Next message: charlie_at_nunya.com: "Re: HELP! CreateProcessWithLogonW issue"

    Relevant Pages

    • RE: default for requiring authentication 2003
      ... Windows 2000 and earlier would allow access as I described and I ... default for requiring authentication 2003 ... resources that have permissions for Everyone unless you enable this setting. ... same username and password as a user on the domain or on the local server. ...
      (Focus-Microsoft)
    • Re: Authentication from Active Directory and Database based user d
      ... with this (I'm not too clear on the permissions to see a page or actual ... You mentioned earlier in the thread that you've used formas authentication ... you don't need separate ... I'm writing a web system ...
      (microsoft.public.dotnet.framework.aspnet.security)
    • Re: pls Help!! After Trust, cannot access from local to foreign do
      ... authentication, they will use the source domain credentials to login. ... Which this is what i want to retain after trust. ... You need to define access by settings permissions on the objects in ... Microsoft MVP - Windows Server - Directory Services ...
      (microsoft.public.windows.server.active_directory)
    • RE: default for requiring authentication 2003
      ... It was a terrible design decision back in NT & Windows 2000, ... default for requiring authentication 2003 ... resources that have permissions for Everyone unless you enable this setting. ... same username and password as a user on the domain or on the local server. ...
      (Focus-Microsoft)
    • Re: IIS 5 looses authenticated user
      ... > We are using NTFS Permissions. ... >> then authentication if any, then web permission, and finally ntfs ... >> localsystem for inetinfo, iwam for dllhost, and request identity is the ...
      (microsoft.public.inetserver.iis.security)
    Loading