Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Simple PL/SQL Problem

Re: Simple PL/SQL Problem

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: 1998/03/12
Message-ID: <3507AD96.42A7AF0A@ubs.com>#1/1

Hi

  1. I recommend that you use synonyms (public or private), so that you don't have to write bozo.table.filed (only table.field).
  2. Select, insert, update, delete priviledges on tables need to be granted directly to the user when they are used in a procedure/package. So login as bozo and grant the required priviledge to krusty.

rgds
eugen Received on Thu Mar 12 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US