Toad World® Forums

Re: hardening Toad for Oracle Professional 10.5

I have been tasked with creating a secure installation of Toad for Oracle Professional 10.5 on a Windows Server 2003 R2.

The main objective is to clear any cached data that Toad writes to the server when operational.

Alternatively I can remap the cached data to a network drive although this has proven problemmatic with other applications I have been dealing with.

I cannot find any details on cached data, registry changes or user data whilst searching google or other Toad related technical documents.

I have also searched for a sample GPO created for Toad but again I am drawing blanks.

Any advice or pointers would be appreciated as I am at a bit of an dead end with this one.

When you say ‘writes to the server’, do you mean like a Citrix
server where Toad is being hosted?

In general, Toad only writes to the user application data directory where Toad
is installed. Toad would never write anything to the database server itself,
unless the user opened a SFTP session or if you used our CRONTAB support.

Toad doesn’t cache any database data to the server or to the client, it
would all reside in memory and be destroyed automatically when Toad closes
– or at least that’s how I understand it.

that’s correct. It also almost writes nothing to the Registry

Message from: Gogs

When you say ‘writes to the server’, do you mean like a Citrix server
where Toad is being hosted?

Exactly, the Toad application will be installed on a Windows 2003 member server.

The server’s primary role is to provide management functionality with access
to various applications for support and development purposes.

In general, Toad only writes to the user application data directory where Toad
is installed. Toad would never write anything to the database server itself,
unless the user opened a SFTP session or if you used out CRONTAB support.

This is what I am insterested in as this funtionality is what I need to provide
the solution for - if at all possible???

The primary objective is to harden the install so no data is written to the
c:\local drive.

What I need to do is locate any data that could or will be written to the
c:\local drive and point to another drive.

Toad doesn’t cache any database data to the server or to the client, it
would all reside in memory and be destroyed automatically when Toad closes - or
at least that’s how I understand it.

I have been searching for some technical documents that actually define how the
data is stored whether in memory or locally and what cach clearing functionality
is perfomed by the application but I have not been able to locate anything.

Ideally I would create a GPO - administrative template defining the role of
Toad.

If you can point me in the direction of some technical doc’s that would also
be usefull.

Thanks for your help on this.

Gordon


Historical Messages

Author: Gordon Leishman
Date: Wed Jun 08 03:32:05 PDT 2011

When you say ‘writes to the server’, do you mean like a Citrix server
where Toad is being hosted?

Exactly, the Toad application will be installed on a Windows 2003 member server.

The server’s primary role is to provide management functionality with access
to various applications for support and development purposes.

In general, Toad only writes to the user application data directory where Toad
is installed. Toad would never write anything to the database server itself,
unless the user opened a SFTP session or if you used out CRONTAB support.

This is what I am insterested in as this funtionality is what I need to provide
the solution for - if at all possible???

The primary objective is to harden the install so no data is written to the
c:\local drive.

What I need to do is locate any data that could or will be written to the
c:\local drive and point to another drive.

Toad doesn’t cache any database data to the server or to the client, it
would all reside in memory and be destroyed automatically when Toad closes - or
at least that’s how I understand it.

I have been searching for some technical documents that actually define how the
data is stored whether in memory or locally and what cach clearing functionality
is perfomed by the application but I have not been able to locate anything.

Ideally I would create a GPO - administrative template defining the role of
Toad.

If you can point me in the direction of some technical doc’s that would also
be usefull.

Thanks for your help on this.

Gordon

__

Author: mark.lerch_828
Date: Tue Jun 07 13:55:35 PDT 2011
that’s correct. It also almost writes nothing to the Registry
__

Author: Jeff Smith
Date: Tue Jun 07 13:55:35 PDT 2011
When you say ‘writes to the server’, do you mean like a Citrix
server where Toad is being hosted? In general, Toad only writes to the user
application data directory where Toad is installed. Toad would never write
anything to the database server itself, unless the user opened a SFTP session or
if you used our CRONTAB support. Toad doesn’t cache any database data to
the server or to the client, it would all reside in memory and be destroyed
automatically when Toad closes – or at least that’s how I understand
it.
__

Author: Gordon Leishman
Date: Tue Jun 07 13:55:35 PDT 2011

I have been tasked with creating a secure installation of Toad for Oracle
Professional 10.5 on a Windows Server 2003 R2.

The main objective is to clear any cached data that Toad writes to the server
when operational.

Alternatively I can remap the cached data to a network drive although this has
proven problemmatic with other applications I have been dealing with.

I cannot find any details on cached data, registry changes or user data whilst
searching google or other Toad related technical documents.

I have also searched for a sample GPO created for Toad but again I am drawing
blanks.

Any advice or pointers would be appreciated as I am at a bit of an dead end with
this one.

__


When you say ‘writes to the server’, do you mean like a Citrix server where Toad is being hosted?

Exactly, the Toad application will be installed on a Windows 2003 member server.
The server’s primary role is to provide management functionality with access to various applications for support and development purposes.

In general, Toad only writes to the user application data directory where Toad is installed. Toad would never write anything to the database server itself, unless the user opened a SFTP session or if you used out CRONTAB support.

**This is what I am insterested in as this funtionality is what I need to provide the solution for - if at all possible???

The primary objective is to harden the install so no data is written to the c:\local drive.

What I need to do is locate any data that could or will be written to the c:\local drive and point to another drive.**
Toad doesn’t cache any database data to the server or to the client, it would all reside in memory and be destroyed automatically when Toad closes - or at least that’s how I understand it.

I have been searching for some technical documents that actually define how the data is stored whether in memory or locally and what cach clearing functionality is perfomed by the application but I have not been able to locate anything.

Ideally I would create a GPO - administrative template defining the role of Toad.

If you can point me in the direction of some technical doc’s that would also be usefull.

Thanks for your help on this.

Gordon

The primary objective is to harden the install so no data is written to the
c:\local drive.

Here’s a very interesting question:

How did you harden SQL Plus to prevent a command of “spool
c:\some_file.dat” from being used?

If you couldn’t stop that, you may be attempting the impossible
considering Toad is a front-end gui to the Oracle client toolsets.

Roger S.

Message from: Gogs

Hi Roger,

It is just cached data that I am interested in. The users will not be able to
copy data to the C:\drive.

Gogs


Historical Messages

Author: Gordon Leishman
Date: Fri Jun 10 06:45:22 PDT 2011
Hi Roger,

It is just cached data that I am interested in. The users will not be able to
copy data to the C:\drive.

Gogs
__

Author: Simoneau, Roger
Date: Wed Jun 08 08:34:06 PDT 2011

The primary objective is to harden the install so no data is written to the
c:\local drive. Here’s a very interesting question: How did you harden SQL
Plus to prevent a command of “spool c:\some_file.dat” from being
used? If you couldn’t stop that, you may be attempting the impossible
considering Toad is a front-end gui to the Oracle client toolsets. Roger S.
__

Author: Gordon Leishman
Date: Wed Jun 08 03:32:05 PDT 2011

When you say ‘writes to the server’, do you mean like a Citrix server
where Toad is being hosted?

Exactly, the Toad application will be installed on a Windows 2003 member server.

The server’s primary role is to provide management functionality with access
to various applications for support and development purposes.

In general, Toad only writes to the user application data directory where Toad
is installed. Toad would never write anything to the database server itself,
unless the user opened a SFTP session or if you used out CRONTAB support.

This is what I am insterested in as this funtionality is what I need to provide
the solution for - if at all possible???

The primary objective is to harden the install so no data is written to the
c:\local drive.

What I need to do is locate any data that could or will be written to the
c:\local drive and point to another drive.

Toad doesn’t cache any database data to the server or to the client, it
would all reside in memory and be destroyed automatically when Toad closes - or
at least that’s how I understand it.

I have been searching for some technical documents that actually define how the
data is stored whether in memory or locally and what cach clearing functionality
is perfomed by the application but I have not been able to locate anything.

Ideally I would create a GPO - administrative template defining the role of
Toad.

If you can point me in the direction of some technical doc’s that would also
be usefull.

Thanks for your help on this.

Gordon

__

Author: Gordon Leishman
Date: Wed Jun 08 03:32:05 PDT 2011
Message from: Gogs When you say ‘writes to the server’, do you mean like
a Citrix server where Toad is being hosted? Exactly, the Toad application will
be installed on a Windows 2003 member server. The server’s primary role is
to provide management functionality with access to various applications for
support and development purposes. In general, Toad only writes to the user
application data directory where Toad is installed. Toad would never write
anything to the database server itself, unless the user opened a SFTP session or
if you used out CRONTAB support. This is what I am insterested in as this
funtionality is what I need to provide the solution for - if at all possible???
The primary objective is to harden the install so no data is written to the
c:\local drive. What I need to do is locate any data that could or will be
written to the c:\local drive and point to another drive. Toad doesn’t cache
any database data to the server or to the client, it would all reside in memory
and be destroyed automatically when Toad closes - or at least that’s how I
understand it. I have been searching for some technical documents that actually
define how the data is stored whether in memory or locally and what cach
clearing functionality is perfomed by the application but I have not been able
to locate anything. Ideally I would create a GPO - administrative template
defining the role of Toad. If you can point me in the direction of some
technical doc’s that would also be usefull. Thanks for your help on this.
Gordon _______________________________________ Historical Messages Author:
Gordon Leishman Date: Wed Jun 08 03:32:05 PDT 2011 When you say ‘writes to
the server’, do you mean like a Citrix server where Toad is being hosted?
Exactly, the Toad application will be installed on a Windows 2003 member server.
The server’s primary role is to provide management functionality with access
to various applications for support and development purposes. In general, Toad
only writes to the user application data directory where Toad is installed. Toad
would never write anything to the database server itself, unless the user opened
a SFTP session or if you used out CRONTAB support. This is what I am insterested
in as this funtionality is what I need to provide the solution for - if at all
possible??? The primary objective is to harden the install so no data is written
to the c:\local drive. What I need to do is locate any data that could or will
be written to the c:\local drive and point to another drive. Toad doesn’t
cache any database data to the server or to the client, it would all reside in
memory and be destroyed automatically when Toad closes - or at least that’s
how I understand it. I have been searching for some technical documents that
actually define how the data is stored whether in memory or locally and what
cach clearing functionality is perfomed by the application but I have not been
able to locate anything. Ideally I would create a GPO - administrative template
defining the role of Toad. If you can point me in the direction of some
technical doc’s that would also be usefull. Thanks for your help on this.
Gordon __ Author: mark.lerch_828 Date: Tue Jun 07 13:55:35 PDT 2011 that’s
correct. It also almost writes nothing to the Registry __ Author: Jeff Smith
Date: Tue Jun 07 13:55:35 PDT 2011 When you say ‘writes to the
server’, do you mean like a Citrix server where Toad is being hosted? In
general, Toad only writes to the user application data directory where Toad is
installed. Toad would never write anything to the database server itself, unless
the user opened a SFTP session or if you used our CRONTAB support. Toad
doesn’t cache any database data to the server or to the client, it would
all reside in memory and be destroyed automatically when Toad closes – or
at least that’s how I understand it. __ Author: Gordon Leishman Date: Tue
Jun 07 13:55:35 PDT 2011 I have been tasked with creating a secure installation
of Toad for Oracle Professional 10.5 on a Windows Server 2003 R2. The main
objective is to clear any cached data that Toad writes to the server when
operational. Alternatively I can remap the cached data to a network drive
although this has proven problemmatic with other applications I have been
dealing with. I cannot find any details on cached data, registry changes or user
data whilst searching google or other Toad related technical documents. I have
also searched for a sample GPO created for Toad but again I am drawing blanks.
Any advice or pointers would be appreciated as I am at a bit of an dead end with
this one. __ _______________________________________
__

Author: mark.lerch_828
Date: Tue Jun 07 13:55:35 PDT 2011
that’s correct. It also almost writes nothing to the Registry
__

Author: Jeff Smith
Date: Tue Jun 07 13:55:35 PDT 2011
When you say ‘writes to the server’, do you mean like a Citrix
server where Toad is being hosted? In general, Toad only writes to the user
application data directory where Toad is installed. Toad would never write
anything to the database server itself, unless the user opened a SFTP session or
if you used our CRONTAB support. Toad doesn’t cache any database data to
the server or to the client, it would all reside in memory and be destroyed
automatically when Toad closes – or at least that’s how I understand
it.
__

Author: Gordon Leishman
Date: Tue Jun 07 13:55:35 PDT 2011

I have been tasked with creating a secure installation of Toad for Oracle
Professional 10.5 on a Windows Server 2003 R2.

The main objective is to clear any cached data that Toad writes to the server
when operational.

Alternatively I can remap the cached data to a network drive although this has
proven problemmatic with other applications I have been dealing with.

I cannot find any details on cached data, registry changes or user data whilst
searching google or other Toad related technical documents.

I have also searched for a sample GPO created for Toad but again I am drawing
blanks.

Any advice or pointers would be appreciated as I am at a bit of an dead end with
this one.

__


No data is cached, so no worries or work for you J

Hi Roger,

It is just cached data that I am interested in. The users will not be able to copy data to the C:\drive.

Gogs

Message from: Gogs

Hey Jeff,

You are a genleman.

I really appreciate your help here.

However if I could find a document that Quest provide that states that ‘no
data is cached to the c:’ then my boss would be satisfied?

I am going to run the File System Watcher util just to double check.

Thanks, Gordon


Historical Messages

Author: Gordon Leishman
Date: Mon Jun 13 01:33:16 PDT 2011
Hey Jeff,

You are a genleman.

I really appreciate your help here.

However if I could find a document that Quest provide that states that ‘no
data is cached to the c:’ then my boss would be satisfied?

I am going to run the File System Watcher util just to double check.

Thanks, Gordon
__

Author: Gordon Leishman
Date: Fri Jun 10 06:45:22 PDT 2011
Hi Roger,

It is just cached data that I am interested in. The users will not be able to
copy data to the C:\drive.

Gogs
__

Author: Jeff Smith
Date: Fri Jun 10 06:45:22 PDT 2011
No data is cached, so no worries or work for you J
__

Author: Gordon Leishman
Date: Fri Jun 10 06:45:22 PDT 2011
Message from: Gogs Hi Roger, It is just cached data that I am interested in. The
users will not be able to copy data to the C:\drive. Gogs
_______________________________________ Historical Messages Author: Gordon
Leishman Date: Fri Jun 10 06:45:22 PDT 2011 Hi Roger, It is just cached data
that I am interested in. The users will not be able to copy data to the
C:\drive. Gogs __ Author: Simoneau, Roger Date: Wed Jun 08 08:34:06 PDT 2011 >>
The primary objective is to harden the install so no data is written to the
c:\local drive. Here’s a very interesting question: How did you harden SQL
Plus to prevent a command of “spool c:\some_file.dat” from being
used? If you couldn’t stop that, you may be attempting the impossible
considering Toad is a front-end gui to the Oracle client toolsets. Roger S. __
Author: Gordon Leishman Date: Wed Jun 08 03:32:05 PDT 2011 When you say
‘writes to the server’, do you mean like a Citrix server where Toad is
being hosted? Exactly, the Toad application will be installed on a Windows 2003
member server. The server’s primary role is to provide management
functionality with access to various applications for support and development
purposes. In general, Toad only writes to the user application data directory
where Toad is installed. Toad would never write anything to the database server
itself, unless the user opened a SFTP session or if you used out CRONTAB
support. This is what I am insterested in as this funtionality is what I need to
provide the solution for - if at all possible??? The primary objective is to
harden the install so no data is written to the c:\local drive. What I need to
do is locate any data that could or will be written to the c:\local drive and
point to another drive. Toad doesn’t cache any database data to the server
or to the client, it would all reside in memory and be destroyed automatically
when Toad closes - or at least that’s how I understand it. I have been
searching for some technical documents that actually define how the data is
stored whether in memory or locally and what cach clearing functionality is
perfomed by the application but I have not been able to locate anything. Ideally
I would create a GPO - administrative template defining the role of Toad. If you
can point me in the direction of some technical doc’s that would also be
usefull. Thanks for your help on this. Gordon __ Author: Gordon Leishman Date:
Wed Jun 08 03:32:05 PDT 2011 Message from: Gogs When you say ‘writes to the
server’, do you mean like a Citrix server where Toad is being hosted?
Exactly, the Toad application will be installed on a Windows 2003 member server.
The server’s primary role is to provide management functionality with access
to various applications for support and development purposes. In general, Toad
only writes to the user application data directory where Toad is installed. Toad
would never write anything to the database server itself, unless the user opened
a SFTP session or if you used out CRONTAB support. This is what I am insterested
in as this funtionality is what I need to provide the solution for - if at all
possible??? The primary objective is to harden the install so no data is written
to the c:\local drive. What I need to do is locate any data that could or will
be written to the c:\local drive and point to another drive. Toad doesn’t
cache any database data to the server or to the client, it would all reside in
memory and be destroyed automatically when Toad closes - or at least that’s
how I understand it. I have been searching for some technical documents that
actually define how the data is stored whether in memory or locally and what
cach clearing functionality is perfomed by the application but I have not been
able to locate anything. Ideally I would create a GPO - administrative template
defining the role of Toad. If you can point me in the direction of some
technical doc’s that would also be usefull. Thanks for your help on this.
Gordon _______________________________________ Historical Messages Author:
Gordon Leishman Date: Wed Jun 08 03:32:05 PDT 2011 When you say ‘writes to
the server’, do you mean like a Citrix server where Toad is being hosted?
Exactly, the Toad application will be installed on a Windows 2003 member server.
The server’s primary role is to provide management functionality with access
to various applications for support and development purposes. In general, Toad
only writes to the user application data directory where Toad is installed. Toad
would never write anything to the database server itself, unless the user opened
a SFTP session or if you used out CRONTAB support. This is what I am insterested
in as this funtionality is what I need to provide the solution for - if at all
possible??? The primary objective is to harden the install so no data is written
to the c:\local drive. What I need to do is locate any data that could or will
be written to the c:\local drive and point to another drive. Toad doesn’t
cache any database data to the server or to the client, it would all reside in
memory and be destroyed automatically when Toad closes - or at least that’s
how I understand it. I have been searching for some technical documents that
actually define how the data is stored whether in memory or locally and what
cach clearing functionality is perfomed by the application but I have not been
able to locate anything. Ideally I would create a GPO - administrative template
defining the role of Toad. If you can point me in the direction of some
technical doc’s that would also be usefull. Thanks for your help on this.
Gordon __ Author: mark.lerch_828 Date: Tue Jun 07 13:55:35 PDT 2011 that’s
correct. It also almost writes nothing to the Registry __ Author: Jeff Smith
Date: Tue Jun 07 13:55:35 PDT 2011 When you say ‘writes to the
server’, do you mean like a Citrix server where Toad is being hosted? In
general, Toad only writes to the user application data directory where Toad is
installed. Toad would never write anything to the database server itself, unless
the user opened a SFTP session or if you used our CRONTAB support. Toad
doesn’t cache any database data to the server or to the client, it would
all reside in memory and be destroyed automatically when Toad closes – or
at least that’s how I understand it. __ Author: Gordon Leishman Date: Tue
Jun 07 13:55:35 PDT 2011 I have been tasked with creating a secure installation
of Toad for Oracle Professional 10.5 on a Windows Server 2003 R2. The main
objective is to clear any cached data that Toad writes to the server when
operational. Alternatively I can remap the cached data to a network drive
although this has proven problemmatic with other applications I have been
dealing with. I cannot find any details on cached data, registry changes or user
data whilst searching google or other Toad related technical documents. I have
also searched for a sample GPO created for Toad but again I am drawing blanks.
Any advice or pointers would be appreciated as I am at a bit of an dead end with
this one. __ _______________________________________ __ Author: mark.lerch_828
Date: Tue Jun 07 13:55:35 PDT 2011 that’s correct. It also almost writes nothing
to the Registry __ Author: Jeff Smith Date: Tue Jun 07 13:55:35 PDT 2011 When
you say ‘writes to the server’, do you mean like a Citrix server
where Toad is being hosted? In general, Toad only writes to the user application
data directory where Toad is installed. Toad would never write anything to the
database server itself, unless the user opened a SFTP session or if you used our
CRONTAB support. Toad doesn’t cache any database data to the server or to
the client, it would all reside in memory and be destroyed automatically when
Toad closes – or at least that’s how I understand it. __ Author:
Gordon Leishman Date: Tue Jun 07 13:55:35 PDT 2011 I have been tasked with
creating a secure installation of Toad for Oracle Professional 10.5 on a Windows
Server 2003 R2. The main objective is to clear any cached data that Toad writes
to the server when operational. Alternatively I can remap the cached data to a
network drive although this has proven problemmatic with other applications I
have been dealing with. I cannot find any details on cached data, registry
changes or user data whilst searching google or other Toad related technical
documents. I have also searched for a sample GPO created for Toad but again I am
drawing blanks. Any advice or pointers would be appreciated as I am at a bit of
an dead end with this one. __ _______________________________________
__

Author: Simoneau, Roger
Date: Wed Jun 08 08:34:06 PDT 2011

The primary objective is to harden the install so no data is written to the
c:\local drive. Here’s a very interesting question: How did you harden SQL
Plus to prevent a command of “spool c:\some_file.dat” from being
used? If you couldn’t stop that, you may be attempting the impossible
considering Toad is a front-end gui to the Oracle client toolsets. Roger S.
__

Author: Gordon Leishman
Date: Wed Jun 08 03:32:05 PDT 2011

When you say ‘writes to the server’, do you mean like a Citrix server
where Toad is being hosted?

Exactly, the Toad application will be installed on a Windows 2003 member server.

The server’s primary role is to provide management functionality with access
to various applications for support and development purposes.

In general, Toad only writes to the user application data directory where Toad
is installed. Toad would never write anything to the database server itself,
unless the user opened a SFTP session or if you used out CRONTAB support.

This is what I am insterested in as this funtionality is what I need to provide
the solution for - if at all possible???

The primary objective is to harden the install so no data is written to the
c:\local drive.

What I need to do is locate any data that could or will be written to the
c:\local drive and point to another drive.

Toad doesn’t cache any database data to the server or to the client, it
would all reside in memory and be destroyed automatically when Toad closes - or
at least that’s how I understand it.

I have been searching for some technical documents that actually define how the
data is stored whether in memory or locally and what cach clearing functionality
is perfomed by the application but I have not been able to locate anything.

Ideally I would create a GPO - administrative template defining the role of
Toad.

If you can point me in the direction of some technical doc’s that would also
be usefull.

Thanks for your help on this.

Gordon

__

Author: Gordon Leishman
Date: Wed Jun 08 03:32:05 PDT 2011
Message from: Gogs When you say ‘writes to the server’, do you mean like
a Citrix server where Toad is being hosted? Exactly, the Toad application will
be installed on a Windows 2003 member server. The server’s primary role is
to provide management functionality with access to various applications for
support and development purposes. In general, Toad only writes to the user
application data directory where Toad is installed. Toad would never write
anything to the database server itself, unless the user opened a SFTP session or
if you used out CRONTAB support. This is what I am insterested in as this
funtionality is what I need to provide the solution for - if at all possible???
The primary objective is to harden the install so no data is written to the
c:\local drive. What I need to do is locate any data that could or will be
written to the c:\local drive and point to another drive. Toad doesn’t cache
any database data to the server or to the client, it would all reside in memory
and be destroyed automatically when Toad closes - or at least that’s how I
understand it. I have been searching for some technical documents that actually
define how the data is stored whether in memory or locally and what cach
clearing functionality is perfomed by the application but I have not been able
to locate anything. Ideally I would create a GPO - administrative template
defining the role of Toad. If you can point me in the direction of some
technical doc’s that would also be usefull. Thanks for your help on this.
Gordon _______________________________________ Historical Messages Author:
Gordon Leishman Date: Wed Jun 08 03:32:05 PDT 2011 When you say ‘writes to
the server’, do you mean like a Citrix server where Toad is being hosted?
Exactly, the Toad application will be installed on a Windows 2003 member server.
The server’s primary role is to provide management functionality with access
to various applications for support and development purposes. In general, Toad
only writes to the user application data directory where Toad is installed. Toad
would never write anything to the database server itself, unless the user opened
a SFTP session or if you used out CRONTAB support. This is what I am insterested
in as this funtionality is what I need to provide the solution for - if at all
possible??? The primary objective is to harden the install so no data is written
to the c:\local drive. What I need to do is locate any data that could or will
be written to the c:\local drive and point to another drive. Toad doesn’t
cache any database data to the server or to the client, it would all reside in
memory and be destroyed automatically when Toad closes - or at least that’s
how I understand it. I have been searching for some technical documents that
actually define how the data is stored whether in memory or locally and what
cach clearing functionality is perfomed by the application but I have not been
able to locate anything. Ideally I would create a GPO - administrative template
defining the role of Toad. If you can point me in the direction of some
technical doc’s that would also be usefull. Thanks for your help on this.
Gordon __ Author: mark.lerch_828 Date: Tue Jun 07 13:55:35 PDT 2011 that’s
correct. It also almost writes nothing to the Registry __ Author: Jeff Smith
Date: Tue Jun 07 13:55:35 PDT 2011 When you say ‘writes to the
server’, do you mean like a Citrix server where Toad is being hosted? In
general, Toad only writes to the user application data directory where Toad is
installed. Toad would never write anything to the database server itself, unless
the user opened a SFTP session or if you used our CRONTAB support. Toad
doesn’t cache any database data to the server or to the client, it would
all reside in memory and be destroyed automatically when Toad closes – or
at least that’s how I understand it. __ Author: Gordon Leishman Date: Tue
Jun 07 13:55:35 PDT 2011 I have been tasked with creating a secure installation
of Toad for Oracle Professional 10.5 on a Windows Server 2003 R2. The main
objective is to clear any cached data that Toad writes to the server when
operational. Alternatively I can remap the cached data to a network drive
although this has proven problemmatic with other applications I have been
dealing with. I cannot find any details on cached data, registry changes or user
data whilst searching google or other Toad related technical documents. I have
also searched for a sample GPO created for Toad but again I am drawing blanks.
Any advice or pointers would be appreciated as I am at a bit of an dead end with
this one. __ _______________________________________
__

Author: mark.lerch_828
Date: Tue Jun 07 13:55:35 PDT 2011
that’s correct. It also almost writes nothing to the Registry
__

Author: Jeff Smith
Date: Tue Jun 07 13:55:35 PDT 2011
When you say ‘writes to the server’, do you mean like a Citrix
server where Toad is being hosted? In general, Toad only writes to the user
application data directory where Toad is installed. Toad would never write
anything to the database server itself, unless the user opened a SFTP session or
if you used our CRONTAB support. Toad doesn’t cache any database data to
the server or to the client, it would all reside in memory and be destroyed
automatically when Toad closes – or at least that’s how I understand
it.
__

Author: Gordon Leishman
Date: Tue Jun 07 13:55:35 PDT 2011

I have been tasked with creating a secure installation of Toad for Oracle
Professional 10.5 on a Windows Server 2003 R2.

The main objective is to clear any cached data that Toad writes to the server
when operational.

Alternatively I can remap the cached data to a network drive although this has
proven problemmatic with other applications I have been dealing with.

I cannot find any details on cached data, registry changes or user data whilst
searching google or other Toad related technical documents.

I have also searched for a sample GPO created for Toad but again I am drawing
blanks.

Any advice or pointers would be appreciated as I am at a bit of an dead end with
this one.

__


Hey Jeff,

You are a genleman.

I really appreciate your help here.

However if I could find a document that Quest provide that states that ‘no data is cached to the c:’ then my boss would be satisfied?

I am going to run the File System Watcher util just to double check.

Thanks, Gordon

Could you show the email from Mark? He’s the Manager of the R&D team
that makes Toad. I can think of no better authority on the subject.

Message from: Gogs

HI Jeff,

Ok that is great. Thanks for your help.

I am sure he will be happy with the explanation.

Rgs, Gordon


Historical Messages

Author: Gordon Leishman
Date: Mon Jun 13 08:36:52 PDT 2011

HI Jeff,

Ok that is great. Thanks for your help.

I am sure he will be happy with the explanation.

Rgs, Gordon
__

Author: Jeff Smith
Date: Mon Jun 13 04:47:46 PDT 2011
Could you show the email from Mark? He’s the Manager of the R&D team that
makes Toad. I can think of no better authority on the subject.
__

Author: Gordon Leishman
Date: Mon Jun 13 01:33:16 PDT 2011
Hey Jeff,

You are a genleman.

I really appreciate your help here.

However if I could find a document that Quest provide that states that ‘no
data is cached to the c:’ then my boss would be satisfied?

I am going to run the File System Watcher util just to double check.

Thanks, Gordon
__

Author: Gordon Leishman
Date: Mon Jun 13 01:33:16 PDT 2011
Message from: Gogs Hey Jeff, You are a genleman. I really appreciate your help
here. However if I could find a document that Quest provide that states that
‘no data is cached to the c:’ then my boss would be satisfied? I am
going to run the File System Watcher util just to double check. Thanks, Gordon
_______________________________________ Historical Messages Author: Gordon
Leishman Date: Mon Jun 13 01:33:16 PDT 2011 Hey Jeff, You are a genleman. I
really appreciate your help here. However if I could find a document that Quest
provide that states that ‘no data is cached to the c:’ then my boss
would be satisfied? I am going to run the File System Watcher util just to
double check. Thanks, Gordon __ Author: Gordon Leishman Date: Fri Jun 10
06:45:22 PDT 2011 Hi Roger, It is just cached data that I am interested in. The
users will not be able to copy data to the C:\drive. Gogs __ Author: Jeff Smith
Date: Fri Jun 10 06:45:22 PDT 2011 No data is cached, so no worries or work for
you J __ Author: Gordon Leishman Date: Fri Jun 10 06:45:22 PDT 2011 Message
from: Gogs Hi Roger, It is just cached data that I am interested in. The users
will not be able to copy data to the C:\drive. Gogs
_______________________________________ Historical Messages Author: Gordon
Leishman Date: Fri Jun 10 06:45:22 PDT 2011 Hi Roger, It is just cached data
that I am interested in. The users will not be able to copy data to the
C:\drive. Gogs __ Author: Simoneau, Roger Date: Wed Jun 08 08:34:06 PDT 2011 >>
The primary objective is to harden the install so no data is written to the
c:\local drive. Here’s a very interesting question: How did you harden SQL
Plus to prevent a command of “spool c:\some_file.dat” from being
used? If you couldn’t stop that, you may be attempting the impossible
considering Toad is a front-end gui to the Oracle client toolsets. Roger S. __
Author: Gordon Leishman Date: Wed Jun 08 03:32:05 PDT 2011 When you say
‘writes to the server’, do you mean like a Citrix server where Toad is
being hosted? Exactly, the Toad application will be installed on a Windows 2003
member server. The server’s primary role is to provide management
functionality with access to various applications for support and development
purposes. In general, Toad only writes to the user application data directory
where Toad is installed. Toad would never write anything to the database server
itself, unless the user opened a SFTP session or if you used out CRONTAB
support. This is what I am insterested in as this funtionality is what I need to
provide the solution for - if at all possible??? The primary objective is to
harden the install so no data is written to the c:\local drive. What I need to
do is locate any data that could or will be written to the c:\local drive and
point to another drive. Toad doesn’t cache any database data to the server
or to the client, it would all reside in memory and be destroyed automatically
when Toad closes - or at least that’s how I understand it. I have been
searching for some technical documents that actually define how the data is
stored whether in memory or locally and what cach clearing functionality is
perfomed by the application but I have not been able to locate anything. Ideally
I would create a GPO - administrative template defining the role of Toad. If you
can point me in the direction of some technical doc’s that would also be
usefull. Thanks for your help on this. Gordon __ Author: Gordon Leishman Date:
Wed Jun 08 03:32:05 PDT 2011 Message from: Gogs When you say ‘writes to the
server’, do you mean like a Citrix server where Toad is being hosted?
Exactly, the Toad application will be installed on a Windows 2003 member server.
The server’s primary role is to provide management functionality with access
to various applications for support and development purposes. In general, Toad
only writes to the user application data directory where Toad is installed. Toad
would never write anything to the database server itself, unless the user opened
a SFTP session or if you used out CRONTAB support. This is what I am insterested
in as this funtionality is what I need to provide the solution for - if at all
possible??? The primary objective is to harden the install so no data is written
to the c:\local drive. What I need to do is locate any data that could or will
be written to the c:\local drive and point to another drive. Toad doesn’t
cache any database data to the server or to the client, it would all reside in
memory and be destroyed automatically when Toad closes - or at least that’s
how I understand it. I have been searching for some technical documents that
actually define how the data is stored whether in memory or locally and what
cach clearing functionality is perfomed by the application but I have not been
able to locate anything. Ideally I would create a GPO - administrative template
defining the role of Toad. If you can point me in the direction of some
technical doc’s that would also be usefull. Thanks for your help on this.
Gordon _______________________________________ Historical Messages Author:
Gordon Leishman Date: Wed Jun 08 03:32:05 PDT 2011 When you say ‘writes to
the server’, do you mean like a Citrix server where Toad is being hosted?
Exactly, the Toad application will be installed on a Windows 2003 member server.
The server’s primary role is to provide management functionality with access
to various applications for support and development purposes. In general, Toad
only writes to the user application data directory where Toad is installed. Toad
would never write anything to the database server itself, unless the user opened
a SFTP session or if you used out CRONTAB support. This is what I am insterested
in as this funtionality is what I need to provide the solution for - if at all
possible??? The primary objective is to harden the install so no data is written
to the c:\local drive. What I need to do is locate any data that could or will
be written to the c:\local drive and point to another drive. Toad doesn’t
cache any database data to the server or to the client, it would all reside in
memory and be destroyed automatically when Toad closes - or at least that’s
how I understand it. I have been searching for some technical documents that
actually define how the data is stored whether in memory or locally and what
cach clearing functionality is perfomed by the application but I have not been
able to locate anything. Ideally I would create a GPO - administrative template
defining the role of Toad. If you can point me in the direction of some
technical doc’s that would also be usefull. Thanks for your help on this.
Gordon __ Author: mark.lerch_828 Date: Tue Jun 07 13:55:35 PDT 2011 that’s
correct. It also almost writes nothing to the Registry __ Author: Jeff Smith
Date: Tue Jun 07 13:55:35 PDT 2011 When you say ‘writes to the
server’, do you mean like a Citrix server where Toad is being hosted? In
general, Toad only writes to the user application data directory where Toad is
installed. Toad would never write anything to the database server itself, unless
the user opened a SFTP session or if you used our CRONTAB support. Toad
doesn’t cache any database data to the server or to the client, it would
all reside in memory and be destroyed automatically when Toad closes – or
at least that’s how I understand it. __ Author: Gordon Leishman Date: Tue
Jun 07 13:55:35 PDT 2011 I have been tasked with creating a secure installation
of Toad for Oracle Professional 10.5 on a Windows Server 2003 R2. The main
objective is to clear any cached data that Toad writes to the server when
operational. Alternatively I can remap the cached data to a network drive
although this has proven problemmatic with other applications I have been
dealing with. I cannot find any details on cached data, registry changes or user
data whilst searching google or other Toad related technical documents. I have
also searched for a sample GPO created for Toad but again I am drawing blanks.
Any advice or pointers would be appreciated as I am at a bit of an dead end with
this one. __ _______________________________________ __ Author: mark.lerch_828
Date: Tue Jun 07 13:55:35 PDT 2011 that’s correct. It also almost writes nothing
to the Registry __ Author: Jeff Smith Date: Tue Jun 07 13:55:35 PDT 2011 When
you say ‘writes to the server’, do you mean like a Citrix server
where Toad is being hosted? In general, Toad only writes to the user application
data directory where Toad is installed. Toad would never write anything to the
database server itself, unless the user opened a SFTP session or if you used our
CRONTAB support. Toad doesn’t cache any database data to the server or to
the client, it would all reside in memory and be destroyed automatically when
Toad closes – or at least that’s how I understand it. __ Author:
Gordon Leishman Date: Tue Jun 07 13:55:35 PDT 2011 I have been tasked with
creating a secure installation of Toad for Oracle Professional 10.5 on a Windows
Server 2003 R2. The main objective is to clear any cached data that Toad writes
to the server when operational. Alternatively I can remap the cached data to a
network drive although this has proven problemmatic with other applications I
have been dealing with. I cannot find any details on cached data, registry
changes or user data whilst searching google or other Toad related technical
documents. I have also searched for a sample GPO created for Toad but again I am
drawing blanks. Any advice or pointers would be appreciated as I am at a bit of
an dead end with this one. __ _______________________________________ __ Author:
Simoneau, Roger Date: Wed Jun 08 08:34:06 PDT 2011 >> The primary objective is
to harden the install so no data is written to the c:\local drive. Here’s
a very interesting question: How did you harden SQL Plus to prevent a command of
“spool c:\some_file.dat” from being used? If you couldn’t stop
that, you may be attempting the impossible considering Toad is a front-end gui
to the Oracle client toolsets. Roger S. __ Author: Gordon Leishman Date: Wed Jun
08 03:32:05 PDT 2011 When you say ‘writes to the server’, do you mean
like a Citrix server where Toad is being hosted? Exactly, the Toad application
will be installed on a Windows 2003 member server. The server’s primary role
is to provide management functionality with access to various applications for
support and development purposes. In general, Toad only writes to the user
application data directory where Toad is installed. Toad would never write
anything to the database server itself, unless the user opened a SFTP session or
if you used out CRONTAB support. This is what I am insterested in as this
funtionality is what I need to provide the solution for - if at all possible???
The primary objective is to harden the install so no data is written to the
c:\local drive. What I need to do is locate any data that could or will be
written to the c:\local drive and point to another drive. Toad doesn’t cache
any database data to the server or to the client, it would all reside in memory
and be destroyed automatically when Toad closes - or at least that’s how I
understand it. I have been searching for some technical documents that actually
define how the data is stored whether in memory or locally and what cach
clearing functionality is perfomed by the application but I have not been able
to locate anything. Ideally I would create a GPO - administrative template
defining the role of Toad. If you can point me in the direction of some
technical doc’s that would also be usefull. Thanks for your help on this.
Gordon __ Author: Gordon Leishman Date: Wed Jun 08 03:32:05 PDT 2011 Message
from: Gogs When you say ‘writes to the server’, do you mean like a
Citrix server where Toad is being hosted? Exactly, the Toad application will be
installed on a Windows 2003 member server. The server’s primary role is to
provide management functionality with access to various applications for support
and development purposes. In general, Toad only writes to the user application
data directory where Toad is installed. Toad would never write anything to the
database server itself, unless the user opened a SFTP session or if you used out
CRONTAB support. This is what I am insterested in as this funtionality is what I
need to provide the solution for - if at all possible??? The primary objective
is to harden the install so no data is written to the c:\local drive. What I
need to do is locate any data that could or will be written to the c:\local
drive and point to another drive. Toad doesn’t cache any database data to
the server or to the client, it would all reside in memory and be destroyed
automatically when Toad closes - or at least that’s how I understand it. I
have been searching for some technical documents that actually define how the
data is stored whether in memory or locally and what cach clearing functionality
is perfomed by the application but I have not been able to locate anything.
Ideally I would create a GPO - administrative template defining the role of
Toad. If you can point me in the direction of some technical doc’s that
would also be usefull. Thanks for your help on this. Gordon
_______________________________________ Historical Messages Author: Gordon
Leishman Date: Wed Jun 08 03:32:05 PDT 2011 When you say ‘writes to the
server’, do you mean like a Citrix server where Toad is being hosted?
Exactly, the Toad application will be installed on a Windows 2003 member server.
The server’s primary role is to provide management functionality with access
to various applications for support and development purposes. In general, Toad
only writes to the user application data directory where Toad is installed. Toad
would never write anything to the database server itself, unless the user opened
a SFTP session or if you used out CRONTAB support. This is what I am insterested
in as this funtionality is what I need to provide the solution for - if at all
possible??? The primary objective is to harden the install so no data is written
to the c:\local drive. What I need to do is locate any data that could or will
be written to the c:\local drive and point to another drive. Toad doesn’t
cache any database data to the server or to the client, it would all reside in
memory and be destroyed automatically when Toad closes - or at least that’s
how I understand it. I have been searching for some technical documents that
actually define how the data is stored whether in memory or locally and what
cach clearing functionality is perfomed by the application but I have not been
able to locate anything. Ideally I would create a GPO - administrative template
defining the role of Toad. If you can point me in the direction of some
technical doc’s that would also be usefull. Thanks for your help on this.
Gordon __ Author: mark.lerch_828 Date: Tue Jun 07 13:55:35 PDT 2011 that’s
correct. It also almost writes nothing to the Registry __ Author: Jeff Smith
Date: Tue Jun 07 13:55:35 PDT 2011 When you say ‘writes to the
server’, do you mean like a Citrix server where Toad is being hosted? In
general, Toad only writes to the user application data directory where Toad is
installed. Toad would never write anything to the database server itself, unless
the user opened a SFTP session or if you used our CRONTAB support. Toad
doesn’t cache any database data to the server or to the client, it would
all reside in memory and be destroyed automatically when Toad closes – or
at least that’s how I understand it. __ Author: Gordon Leishman Date: Tue
Jun 07 13:55:35 PDT 2011 I have been tasked with creating a secure installation
of Toad for Oracle Professional 10.5 on a Windows Server 2003 R2. The main
objective is to clear any cached data that Toad writes to the server when
operational. Alternatively I can remap the cached data to a network drive
although this has proven problemmatic with other applications I have been
dealing with. I cannot find any details on cached data, registry changes or user
data whilst searching google or other Toad related technical documents. I have
also searched for a sample GPO created for Toad but again I am drawing blanks.
Any advice or pointers would be appreciated as I am at a bit of an dead end with
this one. __ _______________________________________ __ Author: mark.lerch_828
Date: Tue Jun 07 13:55:35 PDT 2011 that’s correct. It also almost writes nothing
to the Registry __ Author: Jeff Smith Date: Tue Jun 07 13:55:35 PDT 2011 When
you say ‘writes to the server’, do you mean like a Citrix server
where Toad is being hosted? In general, Toad only writes to the user application
data directory where Toad is installed. Toad would never write anything to the
database server itself, unless the user opened a SFTP session or if you used our
CRONTAB support. Toad doesn’t cache any database data to the server or to
the client, it would all reside in memory and be destroyed automatically when
Toad closes – or at least that’s how I understand it. __ Author:
Gordon Leishman Date: Tue Jun 07 13:55:35 PDT 2011 I have been tasked with
creating a secure installation of Toad for Oracle Professional 10.5 on a Windows
Server 2003 R2. The main objective is to clear any cached data that Toad writes
to the server when operational. Alternatively I can remap the cached data to a
network drive although this has proven problemmatic with other applications I
have been dealing with. I cannot find any details on cached data, registry
changes or user data whilst searching google or other Toad related technical
documents. I have also searched for a sample GPO created for Toad but again I am
drawing blanks. Any advice or pointers would be appreciated as I am at a bit of
an dead end with this one. __ _______________________________________
__

Author: Gordon Leishman
Date: Fri Jun 10 06:45:22 PDT 2011
Hi Roger,

It is just cached data that I am interested in. The users will not be able to
copy data to the C:\drive.

Gogs
__

Author: Jeff Smith
Date: Fri Jun 10 06:45:22 PDT 2011
No data is cached, so no worries or work for you J
__

Author: Gordon Leishman
Date: Fri Jun 10 06:45:22 PDT 2011
Message from: Gogs Hi Roger, It is just cached data that I am interested in. The
users will not be able to copy data to the C:\drive. Gogs
_______________________________________ Historical Messages Author: Gordon
Leishman Date: Fri Jun 10 06:45:22 PDT 2011 Hi Roger, It is just cached data
that I am interested in. The users will not be able to copy data to the
C:\drive. Gogs __ Author: Simoneau, Roger Date: Wed Jun 08 08:34:06 PDT 2011 >>
The primary objective is to harden the install so no data is written to the
c:\local drive. Here’s a very interesting question: How did you harden SQL
Plus to prevent a command of “spool c:\some_file.dat” from being
used? If you couldn’t stop that, you may be attempting the impossible
considering Toad is a front-end gui to the Oracle client toolsets. Roger S. __
Author: Gordon Leishman Date: Wed Jun 08 03:32:05 PDT 2011 When you say
‘writes to the server’, do you mean like a Citrix server where Toad is
being hosted? Exactly, the Toad application will be installed on a Windows 2003
member server. The server’s primary role is to provide management
functionality with access to various applications for support and development
purposes. In general, Toad only writes to the user application data directory
where Toad is installed. Toad would never write anything to the database server
itself, unless the user opened a SFTP session or if you used out CRONTAB
support. This is what I am insterested in as this funtionality is what I need to
provide the solution for - if at all possible??? The primary objective is to
harden the install so no data is written to the c:\local drive. What I need to
do is locate any data that could or will be written to the c:\local drive and
point to another drive. Toad doesn’t cache any database data to the server
or to the client, it would all reside in memory and be destroyed automatically
when Toad closes - or at least that’s how I understand it. I have been
searching for some technical documents that actually define how the data is
stored whether in memory or locally and what cach clearing functionality is
perfomed by the application but I have not been able to locate anything. Ideally
I would create a GPO - administrative template defining the role of Toad. If you
can point me in the direction of some technical doc’s that would also be
usefull. Thanks for your help on this. Gordon __ Author: Gordon Leishman Date:
Wed Jun 08 03:32:05 PDT 2011 Message from: Gogs When you say ‘writes to the
server’, do you mean like a Citrix server where Toad is being hosted?
Exactly, the Toad application will be installed on a Windows 2003 member server.
The server’s primary role is to provide management functionality with access
to various applications for support and development purposes. In general, Toad
only writes to the user application data directory where Toad is installed. Toad
would never write anything to the database server itself, unless the user opened
a SFTP session or if you used out CRONTAB support. This is what I am insterested
in as this funtionality is what I need to provide the solution for - if at all
possible??? The primary objective is to harden the install so no data is written
to the c:\local drive. What I need to do is locate any data that could or will
be written to the c:\local drive and point to another drive. Toad doesn’t
cache any database data to the server or to the client, it would all reside in
memory and be destroyed automatically when Toad closes - or at least that’s
how I understand it. I have been searching for some technical documents that
actually define how the data is stored whether in memory or locally and what
cach clearing functionality is perfomed by the application but I have not been
able to locate anything. Ideally I would create a GPO - administrative template
defining the role of Toad. If you can point me in the direction of some
technical doc’s that would also be usefull. Thanks for your help on this.
Gordon _______________________________________ Historical Messages Author:
Gordon Leishman Date: Wed Jun 08 03:32:05 PDT 2011 When you say ‘writes to
the server’, do you mean like a Citrix server where Toad is being hosted?
Exactly, the Toad application will be installed on a Windows 2003 member server.
The server’s primary role is to provide management functionality with access
to various applications for support and development purposes. In general, Toad
only writes to the user application data directory where Toad is installed. Toad
would never write anything to the database server itself, unless the user opened
a SFTP session or if you used out CRONTAB support. This is what I am insterested
in as this funtionality is what I need to provide the solution for - if at all
possible??? The primary objective is to harden the install so no data is written
to the c:\local drive. What I need to do is locate any data that could or will
be written to the c:\local drive and point to another drive. Toad doesn’t
cache any database data to the server or to the client, it would all reside in
memory and be destroyed automatically when Toad closes - or at least that’s
how I understand it. I have been searching for some technical documents that
actually define how the data is stored whether in memory or locally and what
cach clearing functionality is perfomed by the application but I have not been
able to locate anything. Ideally I would create a GPO - administrative template
defining the role of Toad. If you can point me in the direction of some
technical doc’s that would also be usefull. Thanks for your help on this.
Gordon __ Author: mark.lerch_828 Date: Tue Jun 07 13:55:35 PDT 2011 that’s
correct. It also almost writes nothing to the Registry __ Author: Jeff Smith
Date: Tue Jun 07 13:55:35 PDT 2011 When you say ‘writes to the
server’, do you mean like a Citrix server where Toad is being hosted? In
general, Toad only writes to the user application data directory where Toad is
installed. Toad would never write anything to the database server itself, unless
the user opened a SFTP session or if you used our CRONTAB support. Toad
doesn’t cache any database data to the server or to the client, it would
all reside in memory and be destroyed automatically when Toad closes – or
at least that’s how I understand it. __ Author: Gordon Leishman Date: Tue
Jun 07 13:55:35 PDT 2011 I have been tasked with creating a secure installation
of Toad for Oracle Professional 10.5 on a Windows Server 2003 R2. The main
objective is to clear any cached data that Toad writes to the server when
operational. Alternatively I can remap the cached data to a network drive
although this has proven problemmatic with other applications I have been
dealing with. I cannot find any details on cached data, registry changes or user
data whilst searching google or other Toad related technical documents. I have
also searched for a sample GPO created for Toad but again I am drawing blanks.
Any advice or pointers would be appreciated as I am at a bit of an dead end with
this one. __ _______________________________________ __ Author: mark.lerch_828
Date: Tue Jun 07 13:55:35 PDT 2011 that’s correct. It also almost writes nothing
to the Registry __ Author: Jeff Smith Date: Tue Jun 07 13:55:35 PDT 2011 When
you say ‘writes to the server’, do you mean like a Citrix server
where Toad is being hosted? In general, Toad only writes to the user application
data directory where Toad is installed. Toad would never write anything to the
database server itself, unless the user opened a SFTP session or if you used our
CRONTAB support. Toad doesn’t cache any database data to the server or to
the client, it would all reside in memory and be destroyed automatically when
Toad closes – or at least that’s how I understand it. __ Author:
Gordon Leishman Date: Tue Jun 07 13:55:35 PDT 2011 I have been tasked with
creating a secure installation of Toad for Oracle Professional 10.5 on a Windows
Server 2003 R2. The main objective is to clear any cached data that Toad writes
to the server when operational. Alternatively I can remap the cached data to a
network drive although this has proven problemmatic with other applications I
have been dealing with. I cannot find any details on cached data, registry
changes or user data whilst searching google or other Toad related technical
documents. I have also searched for a sample GPO created for Toad but again I am
drawing blanks. Any advice or pointers would be appreciated as I am at a bit of
an dead end with this one. __ _______________________________________
__

Author: Simoneau, Roger
Date: Wed Jun 08 08:34:06 PDT 2011

The primary objective is to harden the install so no data is written to the
c:\local drive. Here’s a very interesting question: How did you harden SQL
Plus to prevent a command of “spool c:\some_file.dat” from being
used? If you couldn’t stop that, you may be attempting the impossible
considering Toad is a front-end gui to the Oracle client toolsets. Roger S.
__

Author: Gordon Leishman
Date: Wed Jun 08 03:32:05 PDT 2011

When you say ‘writes to the server’, do you mean like a Citrix server
where Toad is being hosted?

Exactly, the Toad application will be installed on a Windows 2003 member server.

The server’s primary role is to provide management functionality with access
to various applications for support and development purposes.

In general, Toad only writes to the user application data directory where Toad
is installed. Toad would never write anything to the database server itself,
unless the user opened a SFTP session or if you used out CRONTAB support.

This is what I am insterested in as this funtionality is what I need to provide
the solution for - if at all possible???

The primary objective is to harden the install so no data is written to the
c:\local drive.

What I need to do is locate any data that could or will be written to the
c:\local drive and point to another drive.

Toad doesn’t cache any database data to the server or to the client, it
would all reside in memory and be destroyed automatically when Toad closes - or
at least that’s how I understand it.

I have been searching for some technical documents that actually define how t

HI Jeff,

Ok that is great. Thanks for your help.

I am sure he will be happy with the explanation.

Rgs, Gordon