Re: How to?: Setup DB schema: How to?

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 27 Apr 2001 11:42:23 +0100
Message-ID: <988368197.14521.0.nnrp-07.c30bdde2@news.demon.co.uk>

Anurag, it is worth creating the objects etc under a different (ie. typically 'not an application user' if you know what I mean) schema, and then, as Daniel says, actually granting user1, user2 etc access to it from there.

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3AE90CD8.58B96C70_at_exesolutions.com...
> Go to otn.oracle.com and technet.oracle.com ... or open a book ... and
look up GRANTS.
>
> A schema owner can grant insert, update, select, and delete privileges on
any table that they own.
>
> Daniel A. Morgan
>
>
>
>
> Anurag Sharma wrote:
>
> > How to create users that share the same schema in Oracle v8.0.5?
> >
> > So if "user1" and "user2" share the same tables, data and other schema
objects when they login via "sqlplus".
> >
> > Thanks,
> > Anurag
>
Received on Fri Apr 27 2001 - 05:42:23 CDT