Re: Big company, little error

Mohamed Romdane wrote:

> Hi,
>
> You have to grant the ROLE to the user after creating it, that contains the
> CREATE SESSION or the ALTER SESSION Privilege !
>
> GRANT CONNECT, RESOURCE TO user;
> or
> GRANT DBA TO user;
>
> Hope that helps ...

It is highly recommended that no one ever grant these roles to anyone except for purposes of training. Oracle, in fact, advises treating them like SCOTT/TIGER which means dropping them on installation. They do not belong in a production database.

The correct thing to do is to create your own roles and then grant the specific privileges required.

Go to http://www.psoug.org
click on Morgan's Library
click on System Privileges

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)