From: Dons <m.v.vandonselaar@donotspam.kpn.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: What Grants/Privs to give to developers/users???
Date: Tue, 10 Oct 2000 16:11:35 +0200
Organization: KPN Telecom
Lines: 18
Message-ID: <jq86usgdgerrj59uj70hob9pc97pg4ahfk@4ax.com>
References: <39DDEBCC.A09A6F55@hsv.boeing.com>
NNTP-Posting-Host: 172.23.121.103
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: hdxl22.telecom.ptt.nl 971187095 20378 172.23.121.103 (10 Oct 2000 14:11:35 GMT)
X-Complaints-To: usenet@kpn.com
NNTP-Posting-Date: 10 Oct 2000 14:11:35 GMT
X-Newsreader: Forte Agent 1.8/32.548


Have you tried to create (public) synonyms for the Tables? 

On Fri, 6 Oct 2000 15:12:12 GMT, Richard Hollingsworth
<william.hollingsworth@hsv.boeing.com> wrote:

>Hi.
>
>I've build the tables for my system and now the developers need access
>to those tables.  I've tried several things but they still can't get
>access to some of the tables.  The only unusual thing about the tables
>is that some of them have sequences.
>
>What is the min. set of grants/roles/privs that I need to give to the
>developers?  What about the users?
>
>Thanks,
>Richard Hollingsworth