Re: Enterprise manager user creation. Whats wrong?

From: Sherlock <sherlock_at_mailmetoday.com>
Date: Wed, 21 May 2003 22:58:48 -0500
Message-ID: <3ECC4AF8.9000007@mailmetoday.com>

Well, actually the earlier ones that i created had only SELECT,UPDATE etc. privelages which were absolutely necessary.

I understand that no one should give the DBA role to others as it may not be supported in later versions. DBA role allows users to tinker with the SYS schema which should not be done at all. There are views available to avoid this.

I was just trying the thing out whether i can see the SYS schema if i create another user with the DBA role. The earlier users i created had specific priveleges (SELECT etc) that were absolutely necessary to them (No unnecesary priveleges were granted).

But i dont still understand why a schema is not added when i add a user.

thanks
karthik

Hans Forbrich wrote:
> Sherlock wrote:
>
>

>>I have granted the user DBA role with admin option. What is surpirsing
>>is that i have done this earlier without any problem.

>
>
> <Sigh>
>
> Did you grant Resource?
>
> And why did you grant DBA? and why the the admin option?
>
>
>
Received on Wed May 21 2003 - 22:58:48 CDT