Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!cs.utexas.edu!usc!apple!well!anderson
From: anderson@well.sf.ca.us (David E. Anderson)
Newsgroups: comp.databases
Subject: Re: need help granting permission to an ORACLE SQL*Form
Keywords: SQL*Forms
Message-ID: <20003@well.sf.ca.us>
Date: 24 Aug 90 01:08:25 GMT
References: <11038@spool.cs.wisc.edu>
Followup-To: comp.databases
Organization: Whole Earth 'Lectronic Link, Sausalito, CA
Lines: 25

In article <11038@spool.cs.wisc.edu> beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung)) writes:
>
>   How do I grant permission to run a form, to another user in
>   Oracle?

Beverly,

If I understand your question correctly, the answer is:

1) make sure the user can read the form (operating system permissions are
   correct and the user knows where the form is stored).
2) provide access to the tables referenced by the form.  Note that this means
   that the user must own the tables OR:
   a) references to tables must use synonyms or include owner userids as well
      as table names and
   b) the owner(s) of the tables must grant access to the user(s)

********************************************************************************
David E. Anderson, Redwood City, CA    (415) 592-1101       
Independent Database Consultant (formerly with Oracle kernel Support Group)
UUCP:  {uunet,pacbell}!well!anderson    Oracorp mail: unix:well!anderson
********************************************************************************
First learn your horn and all the theory.
Next develop a style. Then forget all that
and just play.          Charlie Parker [?]