Re: create account with id & password same

<<< STUFF DELETED >>>>
>|> 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;
<<< STUFF DELETED >>>>

Actually, you're both right - on version 7.x anyway. The advantage of the first over the second is that it allows login by another OS user that knows the Oracle password - without logging, or su'ing , in as doofus. Version 7.x also allows you to change the silly OPS$ prefix in an ora parameter. This might help UNIX folk that want to log in as doofus and not have to quote the $:

         sqlplus ops\$doofus/blahblahblah

These 2 methods of autologin are not real useful over client/server - where everyone's UNIX backend is daemon!

Take care!

Sincerely,

Martin Farber          
Independent Oracle Consultant 	"Jack of all trades and a slave to one."

                        |  NYNEX Science & Technology
                        |  500 Westchester Ave, Rm 1D10
                        |  White Plains, NY  10604
                        |     -----------------
                        |  email: farber_at_nynexst.com
                        |  Voice: 914/644-2656
                        |    FAX: 914/644-2216