.


:




:

































 

 

 

 


SQL Server 2000




 

SQL Server 2000. , . . . .

, , , . , , , . .

. , , . , , . , .

, . , . .

, . , . , , , . . . , . . , , . , .

, . , . , , . , , . SQL Server 2000 .

SQL Server 2000 , . : .

. , , . . : (authentication); (login); (fixed server roles).

: (database user); (fixed database role); (users database role); (application role).

, - , . . , , , , . . . , Windows SQL Server 2000.

SQL Server 2000 (Authentication Modes):

- Windows NT (Windows NT Authentication);

- SQL Server 2000 (SQL Server Authentication).

Windows NT . (logins), , , , , . . (login ID) , -, (SID, Security Identification), . . , login ID . , .

SQL Server SQL Server 2000. Master. , SQL Server, . . , . , . .

SQL Server , Windows NT, , Novell NetWare, Unix . . SQL Server 2000 , SQL Server. , SQL Server Windows 98.

SQL Server Enterprise Manager .

Enterprise Manager , , \Security\Logins. Enterprise Manager, , syslogins (. 11).

:

1. Name. . 128 .

2. Type. :

- NT User ( Windows NT);

- NT Group ( Windows NT);

- Standard ( SQL Server).

3. Server Access. SQL Server 2000:

- Permit ();

- Deny ().

4. Default Database. .

5. User. , .

6. Default Language. , .

. , .

SQL Server 7.0 (roles), SQL Server 6.. SQL Server 2000 , .

. , . . SQL Server 2000 : (server role); (database role).

. , , . (fixed server roles). :

- sysadmin. SQL Server. 2 , .

- setupadmin. , , SQL Server 2000, .

- serveradmin. , , , ..

- securityadmin. , , .

:

1. (fixed database role). , . . :

- db_securityadmin. .

- db_owner. , .. .

- db_denydatawriter. .

- db_denydatareader. .

- db_ddladmin. , .

2. (users database role). , .

3. (application role). , . , . , , .

 

:

1. SQL Server 2000, , . , , , SQL Server 2000, , , . .

2. , , , , , , , . .

. , . , , .

. , . , . , . , , .

.

SQL Server. , (Service Pack) (Patches). , SQL Server . . , , . , , , , . , , .

SQL Server 2000. SQL Server 2000 sysadmin serveradmin . . SQL Server 2000 . , , , .

. ( SQL Server 2000), , . .

, SQL Server 2000. MSSQLServer , .

SQL Server 2000. , , , , , , .

. Windows NT SQL Server, SQL Server 2000.

. , . . , . .

. . . , SQL Server 2000 . , .

. SQL Server 2000 . .

.

. , . , , , , , . .

. , . .

. , .

. , . , .

. . .

. , . . .

. , , .

. , . , . .

. .





:


: 2016-11-18; !; : 1272 |


:

:

, .
==> ...

790 - | 695 -


© 2015-2024 lektsii.org - -

: 0.024 .