Re: oracle client on XP

On Thu, 27 Jan 2005 18:09:58 -0500, Branimir Petrovic <BranimirP_at_cpas.com> wrote:
> 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.

It doesn't have to be that hard.

A domain admin can mount any drive on the network.

subinacle.exe may be used to set permissions from the command line.

It is available at
http://www.microsoft.com/downloads/details.aspx?FamilyID=e8ba3e56-d8fe-4a91-93cf-ed6985e3927b&displaylang=en

eg:

net use z: /delete

net use z: \\some_desktop\c$

subinacl /file "Z:\ORACLE" /grant=everyone=r

Or something like that.

Pointy-clicky-gui stuff is for the birds. ;)

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l