Phil Shrimpton wrote:

>On Monday 21 June 2004 13:18, Jonathan Neve wrote:
>
>Hi,
>
>
>
>>Now, I personally don't like database-level security, I do everything in
>>the user application. Therefore, all my users connect as SYSDBA.
>>
>>
>
>Even if you don't use the built in security and do it all in your app, it is
>still not a good idea for for all users to connect under SYSDBA.
>

Why not?

>Create a
>new user and get them all to connect under that instead.
>
>

This sounds to me like a lot of fuss and bother for nothing. That means
that I'll constantly have to be maintaining the grants for an
all-powerful user, so as to make sure that it always says all-powerful.
If I want it be all-powerful, why not use SYSDBA, which is already
all-powerful?

Jonathan Neve.


[Non-text portions of this message have been removed]