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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Thanks for nothing!!!

Re: Thanks for nothing!!!

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Tue, 10 Oct 2000 15:01:36 -0400
Message-ID: <39E36790.81713DB2@Unforgetable.com>

Jim Gregory wrote:

> 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.
>

Unfortunately way to many people want Oracle to work in the same way as SqlServer. They get a little bit of experience with that toy database and want to translate the experience to an enterprise-level database like Oracle and then become frustrated when the real thing doesn't work in the same way as the toy. Received on Tue Oct 10 2000 - 14:01:36 CDT

Original text of this message

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