Re: Re: RE: Earliest Toad version to support Oracle 11g
Norman Dunbar <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
On 15/02/12 16:56, Patrick wrote:
> So, IIUC, we could just pay attention to capitalize all our passwords
> when migrating to Oracle 11g, communicate it through the team, and this
> should be a non issue.
You could set the initialisation parameter SEC_CASE_SENSITIVE_LOGON =
false to get around the problem. However, that would reduce the security
of the database a tad.
Other things to watch for in a default 11g database are:
* The default profile limits password life time to 180 days then you
have to change it.
* the initialisation parameter (in Enterprise Edition)
CONTROL_MANAGEMENT_PACK_ACCESS defaults to allowing use of the tuning
and/or performance packs even if they are not licensed. Set this to NONE
if you don't have those licenses.
The first is a PITA the second could allow Oracle to sue you. Nice defaults!
--
Cheers,
Norm. [TeamT]
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/