On Wednesday 03 March 2004 15:47, Richard wrote:

Hi,

> How we can create a new user and then "move" our database to this
> user, so that SYSDBA cannot open the database, only the new user is
> allowed to do this?

The SYSDBA user is the equivilent of the Root user under *NIX or
Administrator under Windows, it has access to everything. If you don't want
people to access a DB using SYSDBA, don't give them the password.

Phil
--
Discover a lost art - play Marbles
May 2004
ICQ: 760757 | AIM: pjshrimpton | Y!: pjshrimpton | pjshrimpton@...