How can I prevent user oracle from accessing a database

[fpayande]

I have 3 databases running on a Sun Server and want to create the fourth one. However, I don't want anyone except user HR to to access this Database. All of the DBAs have user oracle access to the Server
thank you in advance.

[davey23uk]

on install of the Oracle softaware you could set the sysdba groups and sysoper group to be that of this HR user and then create this database under that Oracle home.

Why would yu not want your dba's to log onto this database? how are they going to fix it if it goes down?

[gbrabham]

When you create the 4th database, don't recreate all the users ...

or if the users are already there ... lock the account
ie; ALTER USER DAVID account lock;

Hope this helps
Gregg

[fpayande]

Originally posted by davey23uk
on install of the Oracle softaware you could set the sysdba groups and sysoper group to be that of this HR user and then create this database under that Oracle home.

Why would yu not want your dba's to log onto this database? how are they going to fix it if it goes down?

[slimdave]

Originally posted by davey23uk
how are they going to fix it if it goes down?

There's the key point -- you have to have at least one dba user.

[fpayande]

Thanks!!!