Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: If account is locked then users cannot log in with it correct?

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

From: <frank.van.bortel_at_gmail.com>
Date: 16 Aug 2006 06:57:37 -0700
Message-ID: <1155736657.782632.314540@i3g2000cwc.googlegroups.com> 






Mistton schreef:


>

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

>



Explain what you mean by "use STEPH".



scott can indeed still logon, but he cannot do anything
with objects, owned by STEPH, unless scott was GRANTED
THAT RIGHT!


Looks like you have to revoke dba/alter any table from scott....
Received on Wed Aug 16 2006 - 08:57:37 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US