Hello Ian
- We control our databases to such extent that the users have only
select, update, delete and insert permissions
on the tables. All DDL is run by the DBA stuff.
We implemented this policy after some tables were dropped due to the
use of tools that did that automatically
without the user being aware of it.
- If I have a license for log miner (or it is included in the base
package) I do not care what it does inside. I have the right to use it. The
internal workings are not my business .
- I think that you have to configure your DB to use advanced
security. If you did it you use it.
>
> Do you control your databases to such an extent that you can guarantee no
> one will use one of the unlicensed features? Currently we don't install
> any option for which we are not licensed, but I am questioning that
> strategy. The idea of unlinking features which are not licensed is to
> prevent their unauthorized use.
>
> I find Oracle's use of partitioning for logminer interesting. It will not
> do so with the option turned off.
> If one knows that Oracle will use partitioning for logminer and one lets
> it do so despite not being licensed for the option, is that a license
> violation? There's one for the lawyers.
>
> Here's another one to ponder. Oracle's Advanced Networking/Security
> Option, whatever they are calling it today, is installed, despite its not
> being licensed. Another site which is fully licensed for that option
> needs to access your database. The remote site DBA configures the clients
> to use MD5 check-summing and 128 bit encryption. Your database because
> it has the option installed will support this. My gut feeling is that it
> would not be until you knew about . Before you knew, there was no intent
> to defraud.
>
> Once can avoid all this by delinking the unlicensed options.
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> ian_at_slac.stanford.edu
>
>
>
> -----Original Message-----
> Sent: Sunday, March 17, 2002 6:33 AM
> To: Multiple recipients of list ORACLE-L
>
>
> We are working with EE on nt. There is no need to link and all the options
> are available.
> If we work with a new option then we check if we have to pay for it and
> arrange a new contract.
> So, why not do a full link?.
> If oracle wants to use something for internal use why should you care?
>
> Yechiel Adar, Mehish Computer Services
> adary_at_mehish.co.il
>
> > -----Original Message-----
> > From: MacGregor, Ian A. [SMTP:ian_at_SLAC.Stanford.EDU]
> > Sent: Sat, March 16, 2002 4:23 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Installs and Extra Cost Options
> >
> > Sometimes I wonder if the correct thing to do is to install everything
> and
> > then relink the Oracle executable disabling the unpaid for options. My
> > thinking is this: a need arises where the option would be extremely
> > useful; a successful case is made to management; and an agreement is
> > successfully made with Oracle to add the product to our license.
> However,
> > not all files required by the option are on disk. You have also
> > installed the latest patchset which contains bug fixes to the option.
> > You'd have to install from the CD and then again apply the patchset.
> >
> > However if you had everything installed. It would just be a matter of
> > relinking "oracle" to include the new option.
> >
> > We have a very limited concurrent user license for the partitioning
> > option. Here are some of the partitions
> >
> >
> > SQL> select table_owner, table_name, partition_name from
> > dba_tab_partitions;
> >
> > TABLE_OWNER TABLE_NAME
> > PARTITION_NAME
> > ------------------------------ ------------------------------
> > ------------------------------
> > SYSTEM LOGMNR_DICTSTATE$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_DICTIONARY$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_OBJ$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_TAB$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_COL$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_ATTRCOL$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_TS$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_IND$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_USER$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_TABPART$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_TABSUBPART$
> > P_LESSTHAN100
> >
> > TABLE_OWNER TABLE_NAME
> > PARTITION_NAME
> > ------------------------------ ------------------------------
> > ------------------------------
> > SYSTEM LOGMNR_TABCOMPART$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_TYPE$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_COLTYPE$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_ATTRIBUTE$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_LOB$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_CDEF$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_CCOL$
> > P_LESSTHAN100
> > SYSTEM LOGMNR_ICOL$
> > P_LESSTHAN100
> >
> --------------------------------------------------------------------------
> > ---------------------------------------------
> >
> > These our not our partitions, but Oracle's. If you don't delink it,
> > Oracle itself may use it!!!!
> >
> >
> > Ian MacGregor
> > Stanford Linear Accelerator Center
> > ian_at_slac.stanford.edu
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: MacGregor, Ian A.
> > INET: ian_at_SLAC.Stanford.EDU
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
> INET: adary_at_mehish.co.il
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: MacGregor, Ian A.
> INET: ian_at_SLAC.Stanford.EDU
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
INET: adary_at_mehish.co.il
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Mar 19 2002 - 08:28:29 CST
