Database Locking

[shailesh]

Dear DBA's

I want to lock database for other users. This can be done by putting database in Restricted Session mode, but this wouldn't help me because I my users have DBA privilege. So if I put database in resrticted Session mode still he can access data. Any other utility or method if you know to lock the database for DBA privilege user, please let me know.

Thanks
Shailesh

[Slaine]

I should imagine if a user has DBA privileges then there is no straight forward way to lock them out. That is the whole point of having DBA privilege

It would be easier to revoke the DBA privilege from the user and then restrict the database.

Plus, I would never allow a user DBA privileges as you are just asking for trouble

Cheers

[shailendra]

hi

if u want that user will not connect to your database
then revoke "CONNECT" role from that user
after that that user can't connect to the database

[aracnid]

hi,
if your user work via tcp(sql-net) and you have the control on the local machine , stop your listener.