Re: Central User management question
Date: Wed, 11 Jan 2012 10:58:08 -0500
Message-ID: <CADH15GhsMLfh9mTtKnrOB0t9SiqOsTif1VB6duPtJ+QAQ01o1Q_at_mail.gmail.com>
Hello Mike,
> Are there any tools/recommendations that would allow for central
> management of database users? What I am looking for specifically, is a
> single location where we can grant a user access/privileges to a subset
> of the environment. For example, if a new Developer joins the
> organization, we could centrally manage what databases they should have
> access to and allow for a common password on each of the targets. This
> should also allow us the ability to remove someone's access from one
> location without having to visit X number of databases.
>
> I found the 11g Enterprise user security feature which seems to be what
> we are looking for, but I haven't looked into it enough yet to know
> about version compatibility or licensing associated with it.
Yes, as Paul said, you pretty much answered your own question: EUS is the answer.
I'm not an expert in EUS, but David C. Knox is and he wrote a very good book on the topic. If you're interested in EUS, then I'd suggest you read chapter 5 « Identity Management and Enterprise Users » in his book called « Effective Oracle Database 10g Security by Design » ISBN: 0-07-223130-0. It's a very good read and should help you understand what it is and how to implemented it.
HTH, David
> Thanks in advance
>
> Mike
-- David Robillard http://www.linkedin.com/in/davidrobillard -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 11 2012 - 09:58:08 CST