Re: create account with id & password same

In article a9f_at_alva.ge.com, wood_at_dess0.light.ge.com (Bill Wood) writes:
>In article <CvEn57.CM0_at_pica.army.mil>, mellis_at_ramcad.pica.army.mil (Mark Ellis) writes:
>|>
>|> In article <341p2o$821_at_ctsc.hkbc.hk>, s11976_at_ctsc.hkbc.hk (PM Wong) writes:
>|> >Sorry for this trivial question. (The manual explanation is not too
>|> >clear)
>|> >Can I create account for oracle (we run Ver 6.0.31 on AIX) such that the
>|> >id is same as the unix user-id and the password is automatically obtained
>|> >from that of the unix. In other words, the user will go into oracle
>|> >without typing username and password (for sqlplus, sqlforms30 .... etc).
>|> >How do I create such accounts and passwords for oracle with such.
>|> >
>|> ===========================================================================
>|>
>|> When creating the accounts, make the username OPS$username.
>|>
>|> Like this:
>|>
>|> grant connect, resource to OPS$DOOFUS identified by blahblahblah;
>|>
>
>Shouldn't that be:
>
>create user ops$doofus identified externally;
>grant connect, resource to ops$doofus;

Both ways will work. The first way requires less typing. Received on Fri Sep 02 1994 - 14:33:15 CEST