Re: Oracle user management.

"Jeroen" <sp_at_m-up-your-heinie.hole> wrote in message news:3D8E2C1F.C2F1593B_at_planet.nl...
> Hi,
> I'm new to oracle (oh boy).
> I run Oracle 8.1.7. Enterprise on AIX. Is there a way to impplement or
> link oracle to the Unix User database? Or has Oracle it's own user
> management tools? Right now we make our accounts in a table, which is
> very limited.
> I need to secure some parts of the database with strong accounts or even
> with a one-time password system.
>
> Tia,
> --
> Jeroen

O/S authenticated accounts do exist.
Normally this is done by creating accounts like create user ops$jeroen identified externally When you are logged to the server as jeroen, you connect to Oracle just by using a / as you already have been authenticated. As from Oracle 8.0, provided you set up appropiate profile, you can expire and lock accounts, and password expiration and password history has been implemented to. Refer to the create profile command for further details.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address