Re: I need hlp with user configuration

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 Received on Tue Mar 04 2003 - 08:47:12 CST