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

Mistton wrote:

> 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?

It does indeed.

I know more and more organizations that are building application schemas and then after the DDL has build the objects removing the CREATE SESSION privilege. That locks it all down rather nicely. They then regrant it for maintenance purposes.

All applcation access is done from another schema using specific object and column level grants.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org