
6-2 Implement: Making Required Database Administration Changes
If Your Current Version is 4.x Adaptive Server Enterprise 11.5
• System Stored Procedure Database 6-3
• Last Chance Threshold 6-5
New Reserved Words in Version 10.0
These words are reserved as of release 10.0.x and can no longer be
used as database object, user, group, or role names:
Login and Password Changes
Login and password changes include the following:
• New logins and password changes require a minimum 6-byte
password. Existing passwords smaller than 6 bytes are allowed
during upgrade, but the 6-byte minimum is enforced if you add
or change passwords.
• Null passwords are not allowed.
• Expired passwords can cause problems for applications with
embedded passwords. If the
systemwide password expiration is set to 0,
the default, passwords do not expire.
Table 6-1: New reserved words from 4.x to 10.0
arith_overflow escape of rows
at fetch only schema
authorization foreign open shared
cascade identity option some
check identity_insert precision stripe
close isolation primary syb_identity
constraint key privileges syb_restree
current level primary user
cursor mirror read user_option
deallocate national references varying
double noholdlock replace work
endtran numeric_truncation role
Commenti su questo manuale