Hello,

I need to implement Oracle database user management system
in Oracle Application Server 10g environment, and, as I have
not much experience with Oracle, I decided to post here.

The system needs the following functionality:

- mutli-level users management; there is number (say: hundreds)
of users, some of those are managed at central level, whilst
others are created and managed by the branches of the company

- users have different rights assigned to them by the oracle
roles mechanism (some of users need the permissions to manage other
users accounts and priviledges)

- an easy way to manage all the users, by central as well as by
delegated users manager (company branches)

- accountability

- session management (logout/temporarily deny access for specified
users group etc.)


Can it be done in an elegant way using standard oracle 10g mechanisms
or maybe you suggest some other solutions?

I have looked at Oracle Internet Directory for a second and
it seems to satisfy the requirements (moreover, LDAP server
is already running, so it can be used).

Any ideas, comments are more than welcome. Thanks in advance!

Cheers,
maniacx