Re: Permission on User

Frederic wrote:

> Hi,
>
> I would like to create a user, which is nearly a dba, excepted that he
> cannot drop a schema.
>
> How can I do that ?
>
> Thanks
>
> Fred

The way you should create any role.

Create a role and assign to it the privileges required for the person or persons assigned that role to do their job.

You should have dropped the DBA role from Oracle after you installed it.

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