RE: oracle client on XP

> -----Original Message-----
> From: Ron Rogers [mailto:RROGERS_at_galottery.org]
> Subject: oracle client on XP
>
>
> List,
> We are migrating our client PC's to XP and have located a permissions
> problem with the Oracle sub-directories.
> We loaded the PC with xp -sp1 then sp2 as the administrator.
> Then we installed the Oracle 9.2 client. When a reqular user attempts
> to acces the Oracle/home92 the user
> gets "access denied".

Fix for this one is both easy and difficult.

It is easy to fix it - user with local admin "powers" has to log on to each and every XP box with Oracle 9 client, then position himself/herself at the root of the problem (the C:\oracle\ora92 folder), right click on the folder, Properties, "Advanced" button on Security tab, Permission tab, check both check boxes (both "Inherit from parent..." and "Replace permission entries on all child objects...") press on "Apply" button and watch change being "pushed" over gazillion files and folders there.

That was the easy part after which all "normal" (nonadmin that is) users will be able to access stuff from C:\oracle\ora92\bin folder.

Hard part however has to do with "each and every XP box" that local Nimda have to visit in person to clickety-click to bring "in line"...

Resource kit xacls.exe utility may help to some degree with this task: http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/xcacls-o .asp

By the way, this problem is Oracle-on-XP related and predates both the SP1 and SP2.

Logical conclusion (of why on earth it wasn't fixed before) is that XP boxes in your environment run in non-preferred mode!? You see in Winduhs environment it is standard practice that everyone (and his dog) logs/runs as local Admin... Since apparently hardly anyone in "real world" runs XP like your organization tries to, problem escaped detection/fixation cycle up until now ;-)

Branimir

--
http://www.freelists.org/webpage/oracle-l