HDTenEightyP/NetNews huggingface dataset:
Newsgroups: comp.databases.oracle
From: dbenson@us.oracle.com (Daniel Benson)
Subject: Re: Followup to: GRANTing permissions...
Organization: Oracle Corporation, Redwood Shores CA
Date: Wed, 26 Aug 1992 17:21:15 GMT
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

George,

ORACLE7 Roles can be dependent on Unix groups.  That is if you are in a specificUnix group you can be default be in specific Roles.  Below is a short 
description from the ORACLE7 DBA Guide about Roles:

The ORACLE RDBMS provides for easy and controlled privilege management through
the use of roles.  Roles are named groups of related privileges that are 
granted to users or other roles.  The following properties of roles allow for
easier privilege management:

	- Reduced granting of privileges.  Rather than explicitly granting
	  the same set of privileges to many users, the privileges for a
	  group of related users can be granted to a role, and then only
	  the role needs to be granted to each member of the group.

	- Dynamic privilege management.  When the privileges of a
	  group must change, only the privileges of the role need to be
	  modified.  The security domains of all users granted the group's
	  role automatically reflect the changes made to the role.

	- Selective availability of privileges.  The roles granted to a user
	  can be selectively enabled (available for use) or disabled (not
	  available for use).  This allows specific control of a user's
	  privileges in any given situation.

	- Application awareness.  A database application can be 
	  designed to automatically enable (and disable) selective roles
	  when a user attempts to use the application.

Roles are often created for a database application.  An application role
is granted all privileges necessary to run the application.  The application
roll is then granted to other roles or users.  An application can have
several different roles, each granted a different set of privileges that
allow for more or less data access while using the application.

A role can be created with a password to prevent unauthorized use of the
privileges granted to the role.  Typically,  an application is designed
so that when it starts, it enables the proper role.  As a result, an 
application user does not need to know the password for an application's
role.

--------------------------------

Hope this helps, -d
Newsgroups: comp.databases.oracle
From: chris@hawkesbury.uws.EDU.AU (Chris Thompson)
Subject: Mosaix NEW
Summary: New Language Mosaix
Keywords: database language development graphics GUI
Organization: University of Western Sydney
Date: Fri, 28 Aug 1992 04:12:54 GMT




				MOSAIX

I have heard of a product which has not got much press - seems OK
It's called 'Mosaix' from

Mosaix Marketing Pty Ltd
Attn Bill Dalgliesh
L1, 170 Pacific Hwy
Greenwich NSW 2065
Australia
(61)02-9013199
(61)02-9013493 Fax


Abstract:

The Mosaix ADL, ( Application Development Language) is a high  level language
designed to enable rapid development of graphics based applications in an X-
windows environment using object oriented methodologies. Mosaix provides a
graphical user interface toolkit, links to proprietary databases, integration of
raster and vector data, multimedia support and real time event handling.

Comment:
	Seems to offer a reasonable runtime price and for Uni's a reasonable
price for development. Would suit Sun environment. Language is written in 'C'
with its own syntax and lots of inheritable goodies.

Please contact  Bill Dalgliesh for further info.

Kind Regards
c.thompson@uws.edu.au
From: dbenson@us.oracle.com (Daniel Benson)
Newsgroups: comp.databases.oracle
Subject: Re: VMS Oracle files belong to SYSTEM - why?
Date: 26 Aug 92 16:53:33 GMT
Organization: Oracle Corporation, Redwood Shores CA
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

In article <1992Aug25.115821.1@jaguar.uofs.edu> littlec1@jaguar.uofs.edu (Chris Little) writes:
>
>On VMS, why are ORACLE files belonging to SYSTEM, for instance
>DBS files, archive log files, etc?  If they're created by an ORACLE
>process, then surely they should belong to ORACLE and not SYSTEM.
>
>Any insight?  Thanks in advance.
>
>--
>Chris Little, Programmer/DBA                    University Computing Systems
>                                                University of Scranton
>  LITTLEC1@JAGUAR.UOFS.EDU                      Scranton, PA 18510

Chris,

The ORACLE files belong to what ever UIC that created the database.  SYSTEM created your database.  The install guide suggests you use the ORACLE account.  
There are no technical problems with SYSTEM owning those files.  -d
D
D
D
There is no problem with SYSTEM owning the files
Newsgroups: comp.databases.oracle
From: scojam@auto-trol.com (Scott James.)
Subject: Re: olsqlforms crashes
Organization: Auto-trol Technology Corporation
Date: Wed, 26 Aug 1992 23:55:30 GMT

In article <BtJrz0.Guo@fmsrl7.srl.ford.com> hugh@slee01.srl.ford.com writes:
>Does anybody have any experience with the Open Look version of
>sqlforms? I just installed it, and it seems to be kind of buggy. It
>has already crashed several times when I did an execute after a
>generate. Also, some of the pop-ups come up blank at times.
>
>I would appreciate comments and work arounds.
>--
>Hugh Fader
>hugh@slee01.srl.ford.com
>

We have the same problems.  I learned to develop applications with the Motif
implementation and was shocked to see the difference of behavior, bugs...
Once you learn the odd quirks (pains in the rear!) you can work around them.

Also...

Would the person with the "ispell" program please uuencode it and post to this
group?  I know I could use such a utility and I'm sure other readers could find
a use for a public domain speller that works in SQL*Forms.

Thanks in advance!



-- 
--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--
Scott James				scojam@Auto-Trol.COM
Ham (N0LHX) -:- Guitarist               Auto-Trol Technology
HomeBrewer - Student Pilot		Denver, Colorado USA
Newsgroups: comp.databases.oracle
Subject: Installing SQL*Net TCP/IP for MS-DOS
From: jblackwe@eve.wright.edu (John Blackwell)
Date: 2 Sep 92 07:33:45 EST
Organization: Wright State University


Hi,

    I'm trying to install SQL*Net onto a notebook/laptop LAN, but I've
run into a bit of a problem.  CUTCP, the freeware communications package
I'm using, apparently doesn't work with SQL*Net.  I was wondering if
there are any freeware (or extremly cheapware) packages that will work.

    Thanks.

			--John Blackwell
Newsgroups: comp.databases.oracle
From: colten@cbnewsb.cb.att.com (marc.colten)
Subject: Need help in FORM and OCI
Keywords: FORMS,OCI,odefin,fetch
Organization: AT&T
Date: Thu, 3 Sep 1992 17:03:53 GMT


Well here I am again.  I've been using olsqlform30 to create forms
and the OCI (in "C" language) to insert and extract information.
I've been hitting some problems and would appreciate some advice.
Please e-mail and responses and I will summarize and post.

thanks in advance,

marc colten


1)  I created a table with a LONG field for comments.  I can
    add and edit that field just fine (I have a 
    ON-NEW-FIELD-INSTANCE trigger with EDIT_FIELD in it).
    However, my C program will not extract that field in any
    way.

    Some code is :

     struct {
            ...
            ...
            ...
            ...
            ...
	    char TROUBLE[65535];
	    } attr[3];


     odefin(C0,5,attr[1].TROUBLE,(int) strlen(attr[1].TROUBLE),LONG,
                   -1,dum,NULL,-1,-1,&dum2,&dum3);

    
   When I fetch the data, everything else comes up okay, but
   I get a message that the field has been truncated.  I
   print it out character by character (assuming it was not
   NULL terminated) and it's empty.  I have tried putting the
   field length directly into the odefin, and the field length
   in the structure has been anywhere from 100 to 67000.   I have
   used LONG and STRCHR as identifiers.  Nothing.


2) I have used structures with no array:

     struct {
            ...
            ...
            ...
            ...
            ...
	    } attr;


and it does not work.  If I use attr[3], I can't get the
data into attr[0].  But if I use a number > 1 and assign
the output to attr[1].<field>, it always works.  Can anyone
explain this?

3)  Can you do a query on a detail block and have the relevant
    information come up in the master block?  It works fine
    the other way.  I do a query in a master block and it brings
    up two records in the detail (which it should).  I've tried
    doing the reverse and it won't work.  I set up a KEY-ENTQRY
    trigger on the detail block with various commands:

         go_block('<master>');
         :<master>.field := <detail>.field;
         execute_query;
    
    But no luck.  execute_query wipes out the master block
    before it does anything. What I wind up with is the
    detail block shows the information what I wanted, while
    the master block shows the data you'd get from a blank field.
    
    What I want to do is:
        enter the query in the detail block.
        execute the query.
        The master block queries it's table to come up
          with the appropriate information based on the data
          placed in the detail.
        The master executes a query so the master and the detail
          (two records now) show the matching data.

    Is this possible?


4)  Can you do a LOV on a block, or failing that on a non-enterable
    field?  I just want a list relevant to the data I've queried
    as an alternative to a second page, which is not really necessary
    and really slows things down.



Thanks
Subject: Forms3 LOV
Distribution: world
Organization: Twod's Software Factory
Date: Thu, 3 Sep 1992 17:27:16 +0000

--
Ian Parkin, twod@socrates.demon.co.uk

For a given field in a V3 form I would like **simple** way of constructing
a LOV such that I could display within the LOV some hard-coded values.

i.e. :
====

For a field that accepts only 'Y' or 'N' as input I would like these values 
to appear within the fields LOV.

This seems a simple thing to do, but using a select such as 

SELECT 'Y', 'N'
INTO   :my_field
FROM   system.dual

within the field definition screen gives a concatenation of Y and N within
the LOV.

I have tried various other methods, but all to no avail.

Does anyone know of a simple way of doing this ?

By simple I mean little or no maintenance overheads ( i.e. no temporary 
tables, etc ), and if possible a solution consisting soley of the LOV select
text.

OK, I know these values are hard-coded and thus could go in the database, but
its just one of those things that has been bugging me.

Cheers

IAP
From: peyton@itd.nrl.navy.mil (Rodney D. Peyton,B16/R132,X79091,)
Newsgroups: comp.databases.oracle
Subject: GUI to Oracle
Date: 31 Aug 92 17:57:21 GMT
Reply-To: peyton@itd.nrl.navy.mil
Organization: Information Technology Division, Naval Research Laboratory

We are looking for a GUI to the ORACLE DBMS that works similar to the
way oracle's sql_forms package works when combined with sqlnet. We
can't use oracle's sql_forms and sqlnet, because oracle isn't willing
to give/sell us enough detail information (source code) about the
protocol between the client application and orasrv daemon running on
the remote system.
 
Apparently, the way sql_forms et. al work over sqlnet tcp/ip is that
you have a server application (orasrv) running on the remote system
waiting to accept a connection on a socket. Once a client such as
sql_forms connects, the server forks off a child process to handle the
client connection.
 
We want to capture the sql commands that the client sends to the server and
the child process of the server, modify them, and send them on to orasrv or
the children of the orasrv.
 
If you have a GUI that would allow us to do this, we would be willing to 
purchase the source code from you. The client code should run under SunOS/X11 or
on a PC running DOS and/or Windows, but at this point we will accept code that
runs on just about anything if the UI is decent. The server code, must run
under SunOS 4.x. I can be reached at the address/phone number below.
 
 
Rodney Peyton
 
202-767-9190
peyton@itd.nrl.navy.mil
From: sjs@netcom.com (Stephen Schow)
Newsgroups: comp.databases.oracle
Subject: Other Forms than SQL*FORMS
Date: 27 Aug 92 17:19:34 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest)

Anyone know much about other forms generation packages that work with the
Oracle RDMS.  This could include Client/Server as well as UNIX based.

I have heard of one package called JAM, but I don't know much about it.
-- 
------------------------------------------------------------------
Steve Schow    | But you don't have to use the claw, if you
sjs@netcom.com | pick the pear with the big paw paw......
               | Have I given you a clue......?
               |                       - Baloo the Bear
------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: GO.MSB@isumvs.iastate.edu 
Subject: Re: version 7
Organization: Iowa State University, Ames IA
Distribution: usa
Date: Mon, 31 Aug 1992 20:42:30 GMT

In article <1992Aug31.071727.332@doc.bmd.trw.com>,
rthorstr@doc.bmd.trw.com writes:
>In article <1992Aug29.012028.9273@cs.UAlberta.CA>, ken@cs.UAlberta.CA (Huisman Kenneth M) writes:
>> Does anyone know when exactly oracle version 7 comes out for the PC???
>
>ORACLE has announced that version 7 WILL NOT be implemented on the PC.
>
-----------------------------------------------------------
The article in InfoWorld stated NOT FOR DOS -- it is to be a Windows NT
product only.  Do you have an update on this?  Thanks.

Marvin Beck    Iowa State University
Newsgroups: comp.databases.oracle
From: nakkala@cs.tamu.edu (Venkatesh Nakkala)
Subject: HELP !...regarding use of LOV to select multiple values...
Organization: Computer Science Department, Texas A&M University
Date: Mon, 31 Aug 1992 02:00:19 GMT


   Can anyone out there give me suggestions as to how I could do 
   the following. 

  1]  I have a block that consists of fields from a view based on three
   tables.One of these fields can take more than one value..in the 
   database these values would correspond to different tuples in one
   of the tables involved. Right now I just have the usual LOV
   text that selects into the field and so cant allow for more
   than one to be selected. Any ideas ?...I would like the user to
   be able to just select all the values off the LOV popup . 

   What I want to do  is similar to the "select columns" option 
   in the default block definition form. 

  2] When the fields in the form are of length 1, the value entered in
  the field is not visible to the user until he presses NXTFLD.If I make 
  the field length 2 then it would create problems if the user enters
  2 characters in the field(during commit).

   Thanks in advance,

   Venkatesh Nakkala
   
-----------------------------------------------------------------------------
		     Venkatesh  Nakkala    nakkala@neuron.tamu.edu 
 Off : (409)845-5469                       Res : (409)268-7404
 Dept. Of Comp Sci.,Texas A & M Univ. 
--
-----------------------------------------------------------------------------
		     Venkatesh  Nakkala    nakkala@neuron.tamu.edu 
 Off : (409)845-5469                       Res : (409)268-7404
 Dept. Of Comp Sci.,Texas A & M Univ. 
Newsgroups: comp.databases.oracle
From: kdady@src.honeywell.com (Ken Dady)
Subject: keypad & sql*forms
Organization: Honeywell Systems & Research Center
Date: Thu, 3 Sep 1992 13:38:06 GMT


Howdy,

This has got to be a FAQ but since I haven't seen a
list here goes:

Is there a way to re-define the numeric keypad on a
VT100, Sun keyboard, Mac (running telnet) to be used
as a 'normal' keypad with SQL*forms? i.e. Keys
interpreted as numbers instead of functions. The
numlock key seems to have no effect.

In case it matters I'm using oracle 6.0.30 on a Sun 4 
and accessing it via a Mac SE with an extended keyboard
using BYU telnet 2.4.6 w/MacTCP.

Thanks!

kdady@ssdc.honeywell.com
From: kml@cellar.org (John Galt)
Newsgroups: comp.databases.oracle
Subject: Re: Declaring sequence number qualifiers in Pro*c
Date: 26 Aug 92 12:27:23 GMT
Organization: The Cellar BBS and public access system

mcs@wet.UUCP (Gil Nardo) writes:

> suthemb1@jhuapl.edu (Marvin Suther) writes:
> > 
> >  I am writing a Pro*C application and am trying to access an already existi
> > sequence number. However, no matter how I declare the sequence number id, I
> > receive an error message  that the sequence id  does not exist. All 
> > documentation only references the use and not the declaration. Anyone know 
> > how this is declared?
> > 
> 
> 	Perhaps the problem is with priveleges.  The problem may be that
> your app/user does not have access to that particular sequence number.
> If so, then you need to grant priveleges via sqlplus, e.g.,

The problem may also be caused by trying to reference SEQ.CURRVAL before
referencing SEQ.NEXTVAL.  In some versions of Oracle, you have to first
select Nextval before asking for Currval, otherwise it gives a cryptic
error.  No, I'm not making this up.



               Personally, I skip the posts and just read the sigs.

  kml%cellar@tredysvr.tredydev.unisys.com - My other account is a Mercedes.
Newsgroups: comp.databases.oracle
From: dbenson@us.oracle.com (Daniel Benson)
Subject: Re: maxdatafiles -- inquiry/update
Keywords: maxdatafiles
Organization: Oracle Corporation, Redwood Shores CA
Distribution: usa
Date: Thu, 27 Aug 1992 16:01:52 GMT
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

In article <z=cnvvk.esc@netcom.com> esc@netcom.com (Steve Etchelecu) writes:
>
>I am looking for a method to inquire on the current value for
>the MAXDATAFILES parameter which was set when a database is created.
>
>More importantly, I am looking for a method to increase this value
>without having to recreate the database.
>
>Any help would be greatly appreciated.
>
>Thanks,
>Steve Etchelecu
>esc@netcom.netcom.com

I don't know any way to find the current MAXDATAFILES; however, if you
want to increase it with out re-creating your database use the 
CREATE CONTROLFILE command to re-create your control files with a larger
value for MAXDATAFILES.  I don't think the command is documented in the
DBA guide for V6, it was added in 6.0.27 I believe.  You will find it  
documented in the readme file in the rdbms directory.  Be very careful
with this command, make sure you have a cold backup of all your database
files (i.e. redo,control, and data) before using it. Good luck, -d
From: mmcgreg@uswnvg.com (Mark McGregor)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle Precompilers and Nulls
Date: 4 Sep 92 18:41:35 GMT
Distribution: usa
Organization: U S WEST NewVector Group, Inc.
X-Newsreader: Tin 1.1 PL5


First, this is not a precompiler "problem".  It is an SQL issue.
The same results are obtained in SQL*Plus if you join two tables
on columns which allow nulls.  The nulls are not evaluated in
a join statement using "=" (as far as I know).  Here are two
possible alternatives.

1.  Nvl( TNAME.CNAME, '?????' ) = Nvl( :hostvar, '?????' )

    where ????? is a value of your choice which should NOT be in
    the range of CNAME for this to work properly.  If I use this
    type of command I try to pick some very strange value.  But
    be careful on dates and numbers (especially numbers since there
    are fewer strange values).  I personally would not use this
    construct in very much (if any) production code.  It works fine
    for quick and dirty stuff.

2.  ( ( TNAME.CNAME is NULL And :hostvar is NULL )
    Or
      ( TNAME.CNAME is Not NULL And :hostvar is Not NULL And
        TNAME.CNAME = :hostvar ) )

    I often use this construct (or a similar one) to handle optional
    variables on a query.  This should return "matches" on null
    columns (i.e. where both the host variable and table.column are
    NULL).  It does not, however, return stuff is one of the two
    columns is NULL and the other has a value.  There are of course
    ways to do this.

    Also, as I'm sure some people will point out, the "TNAME.CNAME is
    Not NULL And..." line is optional.  You could use:

    ( ( TNAME.CNAME is NULL And :hostvar is NULL )
    Or
      ( TNAME.CNAME = :hostvar ) )

I hope this is of some redeeming value.


Mark McGregor

"Ancient definition of Oracle:  A place where people queried pig livers
 in order to make important decisions.  What a marvelous history for
 a database manager..."

Newsgroups: comp.databases.oracle
From: reynolds@sun44.synercom.hounix.org (Jeff Reynolds)
Subject: Re: Customization of SQL*Forms.
Keywords: SQL*Forms, Oracle CASE
Organization: Synercom Technology, Inc., Houston, TX
Date: Fri, 28 Aug 1992 02:02:00 GMT

I'm in no position to confirm the rumour about the .INP files, but last week
some Oracle reps came out to our organization to give a technical overview 
of Oracle7, and a glimpse of future product directions.  Part of the
discussion centered around SQL*Forms 4.0, and according to the reps, Oracle
is "considering" the elimination of the .INP files in 4.0.  Apparently the
matter has not been finalized yet, and it was suggested that our concerns be
aired in order to help Oracle make their "decision".

  Issue #1 - Change control - Tools like RCS and SCCS (UNIX) or CMS (VMS) are
             essential in a multi-person development environment to prevent
             simultaneous (accidental) modifications.  Developers "check out"
             the .INP file to ensure exclusive access to the form definition
             during the development cycle.
  Issue #2 - Version control - Every once in a while, Murphy strikes and 
             something goes drastically wrong.  It becomes necessary to go 
             back to a previous generation of a form and reengineer 
             the changes.  With SCCS or CMS, these earlier generations of 
             .INP files can be reconstructed and reserved.  
  Issue #3 - It is also valuable to be able to determine what changed between 
             generations (and not necessarily adjacent generations).  To do 
             this requires "differenceable" code (aka, ordered text files).
             (Note that .REX files from SQL*ReportWriter are hardly
             "differenceable".)
  Issue #4 - Many development shops are willing to circumvent "supported"
             actions if the result is going to be cost effective (faster),
             as long as safety/reliability is not significantly impacted.
             The direct editing of .INP files, although not supported by
             Oracle, is relatively safe (especially with a code management
             system where the original version can be refetched) and is
             a proven time-saver (global edits, search/replace operations).
             The cost to apply the same change (such as boilerplate text) to
             many forms can be enormous compared to using a stream editor like 
             SED on .INP files.

IMNSHO, until Oracle can provide change control, version control, the ability
to identify differences between different forms or generations of the same
form, AND global search/edit capabilities, there will be a STRONG DEMAND for 
.INP files (or their equivalent) by most development shops doing serious 
development work.  

					...jeff reynolds

Disclaimer:  Blah blah my opinions blah blah not necessarily my company's blah 
blah blah.