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: sybrandb <sybrandb_at_gmail.com>
Date: 16 Aug 2006 07:13:57 -0700
Message-ID: <1155737637.497569.214700@h48g2000cwc.googlegroups.com>

Mistton wrote:
> 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.
> >

SIGH, That is what the SYNONYMS are for. You WON'T have to change anything!!!!

Please read up on synonyms and grants.
I already provided you with the *exact* commands!!!!! What should I do *more*?????

-- 
Sybrand Bakker,
Senior Oracle DBA
Received on Wed Aug 16 2006 - 09:13:57 CDT

Original text of this message

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