Re: Thanks for nothing!!!

You don't really get it. We cannot help you without information like what are the developers doing? Do they need to create tables, procedures, triggers? Do they need to access each others objects? Do they need a sub-set of DBA privs? Does the application code that the users run need to create tables, indexes, other objects? Do they need to run stored procedures? Do some users update tables while others only do selects? Do the users log in as themselves and need access to 1 or more schema's data or do they log in as the owner of the objects?

The most basic documentation contains information on the privileges, roles, grants, and synonyms that make up the ORACLE security sub-system. Sequence values stored in table columns need nothing more than regular access to the table/columns. Sequences themselves need to have grants and synonyms set up to be accessible to others - just like any other object in ORACLE.

ORACLE is a very complex animal. Some questions that may seem simple do not have simple or easy answers.

HTH

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR
"Opinions are my own and do not reflect
  those of Keane or my clients"
Richard Hollingsworth <william.hollingsworth_at_hsv.boeing.com> wrote in
message news:39E21276.DF1C6424_at_hsv.boeing.com...


> Dosen't matter!  Not the point!

>

> I simply need to know that the min privs/grants are for each group,

 please.


>

> I CANNOT find these liseted, and simply want to know what they are.

>

> Thanks again,

> Richard H

>

> STiger2000 wrote:

>

> > We're a little light on information here.

> > Two rules of thumb: (ascending soap box)

> > 1. Developers belong on a development system. (Which also may be read

> > as: Developers DO NOT belong on a production system.)

> > 2. Users (application users, developers, testers, trainers, etc) should

> > only be given the MINIMUM roles and privileges needed to do there job.

> > Convenience DOES NOT equate to necessity.

> > (descending soap box)

> > jc

> > http://www.networkessentials.com/certified/ocp

> > In article <39DDEBCC.A09A6F55_at_hsv.boeing.com>,

> >   Richard Hollingsworth <william.hollingsworth_at_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

> > >

> > >

> >

> > Sent via Deja.com http://www.deja.com/

> > Before you buy.

>