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 . .
.
. , . , , , , , . .
. , . .
. , .
. , . , .
. . .
. , . . .
. , , .
. , . , . .
. .