Seagate ST43401N/ND Informations techniques télécharger pdf (Page 83)

Migrating to Sybase Adaptive Server Enterprise 11.5 6-3

Adaptive Server Enterprise 11.5 If Your Current Version is 4.x

• You need not change existing passwords; however Adaptive

Server begins enforcing the new password rules the ﬁrst time

sp_password is invoked.

➤

Note

SQL Server 11.1 enables you to protect sensitive data with several security

features, including user identiﬁcation and authentication, discretionary

access controls, division of roles, and event auditing. See the

Security

Administration Guide

and the

Security Features User’s Guide

The following changes to password security should be noted:

• NULL passwords are no long allowed

• All passwords must be a minimum of 6 bytes

• Passwords expire after a conﬁgurable length of time.

RUN File Renamed

On UNIX platforms, startserver looks for the default ﬁle called

RUN_SYBASE, rather than RUNSERVER. If a ﬁle called

RUNSERVER resides in the install directory,

sybinit changes its name

to RUN_SYBASE during upgrade.

Changes you may need to make are as follows:

• If you use the

startserver -f RUNSERVER command to start your

server, you must change it to

startserver -f RUN_SYBASE.

• If you start the server automatically when you boot your

machine, change your system start-up ﬁle if necessary.

System Stored Procedure Database

As of SQL Server 10.0, a new system database, sybsystemprocs,

contains all system stored procedures. This change may impact your

system in the following ways:

• Non-default permissions on system procedures must be

explicitly changed in sybsystemprocs.

• Scripts that reference catalog tables must explicitly reference

them as master.dbo.table_name.

• If user procedures are put here, they must explicitly reference

user tables as database.owner.table or database..table.

1 2 ... 78 79 80 81 82 83 84 85 86 87 88 ... 171 172

Pas de commentaire

Seagate ST43401N/ND Informations techniques Page 83