If account is locked then users cannot log in with it correct?

In article <nnb5e25q6qr0siup2r7361f7o9jv8uom50_at_4ax.com>, sybrandb_at_hccnet.verwijderdit.nl wrote:
>On 15 Aug 2006 17:11:01 -0500, mistonl_at_mail.com (Mistton) wrote:

>>our goal is that users would continue to user STEPH accounts with same
>>password,etc and no need to change app code, not sure how this would work.
>
>No, no exp/imp needed.
>
>What one would do:
>
>the existing STEPH remains.
>You CREATE an user called STEPH_USER (or whatever).
>STEPH grants you SELECT, INSERT, UPDATE, DELETE on every table, view
>STEPH grants EXECUTE on every procedure, function, package.
>
>You connect as STEPH_USER.
>
>You issue CREATE SYNONYM <original_table_name> FOR STEPH.<original
>table_name> for *every* table, view, procedure, function, package.
>
>Now you can
>select * from <original_table_name>
>just like before under STEPH_USER.
>
>Now you LOCK the STEPH account, and throw away the key.

If I lock STEPH (ALTER USER STEPH ACCOUNT LOCK) then does that not stop users from being able to login and use STEPH. would i not have to go to all the app code and where STEPH appears change it to STEPH_USER?

>If you would need to change anything in the origingal STEPH account
>(by change I mean 'ALTER TABLE' or something like that), either you
>need to UNLOCK the account, or a DBA need to do it on STEPH's behalf.
>
>Hope this helps and makes it clear.
>
Received on Wed Aug 16 2006 - 05:22:04 CDT