Skip to Main Content
  • Questions

  • Impossible passwords no longer allowed

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Andrew.

Asked: January 24, 2017 - 5:45 pm UTC

Last updated: January 25, 2017 - 1:50 am UTC

Version: 12.1

Viewed 1000+ times

You Asked

Prior to Oracle 12 we used to be able to set impossible passwords by doing something like this

ALTER USER audsys
IDENTIFIED BY VALUES 'ThisIsNotTheDefaultPassword';

Since Oracle 12 when we do that, we get the exception
ORA-02153: invalid VALUES password string

How is a good thing that we may no longer set impossible passwords?

and Connor said...

See the comments section in my blog post

https://connormcdonald.wordpress.com/2014/08/09/12-1-0-2-security-grrr/



Is this answer out of date? If it is, please let us know via a Comment
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 latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.