Skip to Main Content
  • Questions

  • if the oracle profile can affect sys account

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, ezio.

Asked: October 29, 2015 - 7:28 am UTC

Last updated: October 29, 2015 - 10:14 pm UTC

Version: 9i and 10g

Viewed 1000+ times

You Asked

Hi:
when I use oracle profile to control the password policy and the others.
but it seems that it can not affect sys account.
When I attempted three times of wrong passwords ,the sys account is still open. is that normal?
If it is normal, is there any other ways to approval my request.

and Chris said...

It's not possible to do lock out the sys account like this. See MOS notes 289898.1 & 225529.1 and the following article by Pete Finnigan:

http://www.petefinnigan.com/ramblings/failed_login_attempts.htm

You can lock the sys account manually with "alter user sys lock" though:

https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:18785088712670

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

one more question

ezio, October 29, 2015 - 11:46 am UTC

thanks for answer,one more question ,Is there any affect if the 'system' account is locked or expired.
Chris Saxon
October 29, 2015 - 10:14 pm UTC

There should not be. My preference for DBA accounts is that individual accounts are created for DBA's so its easier to track activity.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.