Re: I need hlp with user configuration

Ed Stevens wrote:

> On Thu, 20 Feb 2003 17:59:32 GMT, Karsten Farrell
> <kfarrell_at_belgariad.com> wrote:
>
> <snip>
> >
> >You should change the password of both of these accounts. To add a
> >"typical" user with a minimum of privileges, open a DOS window:
> >
> > sqlplus system/manager
> > create user myuser identified by somepassword
> > default tablespace utl
> > temporary tablespace temp;
> > grant connect to myuser;
> <snip>
>
> Karsten,
>
> I believe that granting the 'connect' role is granting a lot more than
> 'minimum' privileges. The role has the following system privileges:
>
> CREATE CLUSTER
> CREATE DATABASE LINK
> CREATE SEQUENCE
> CREATE SESSION
> CREATE SYNONYM
> CREATE TABLE
> CREATE VIEW
And Oracle does not recommend anything other than using CONNECT, RESOURCE, and DBA as guides for building your own roles: After which they should be dropped.

The minimum privilege is CREATE SESSION.

Daniel Morgan Received on Tue Mar 04 2003 - 16:09:49 CST