Re: How to organize passwords?

What exactly do you mean?

Do you mean our admins have got so many Oracle passwords we can never remember them all. In that case I'd suggest using some external authentication system for your dbas then you get single sign on. Or you could keep a password file in a secure area (to which of course only the dbas would know the password - you can see where this is going).

alternatively you might mean we have so many database users we can't keep track of their passwords. In which case my response would be that you shouldn't have to. all you should be able to do is change the password for your users and set it to expire immediately. (and maybe unlock the account if it is configured to lock). A password system that requires the sys admins to know users passwords is a buggy system. (btinternet please take note).

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Martin Doering" <doeringm_at_gmx.de> wrote in message
news:3c69152e.108923413_at_news.mn.man.de...


> Hello, Admins!

>

> How do you organize your trillions of passwords? It's getting more and

> more. So I'm looking for a secure way to organize and access password

> data by our four admins.

>

> How do you do it?

>

> --

> Martin Doering