Microsoft SQL Server 2000 .
. . , , SQL Server Windows NT/2000 . , . , SQL Server. SQL Server, , . . , ( ) , . .
. , , , . , . SQL Server 2000 .
:
- ;
- ;
- .
:
- ;
- ;
- ;
- .
. SQL Server 2000 , , .
, SQL Server, , . , SQL Server. . : , , . .
, , .
Transact-SQL, , sp_addlogin. SQL Server.
sp_grantlogin SQL Server Windows NT.
. , . , , . SQL Server, .
|
|
: dbo guest. , guest. guest .
guest , master tempdb.
, .
, , , , , . ., . . , . .
. , .
SQL Server . , , , .
. , SQL Server 7.0 , . , , SQL Server. . ( ), , .
SQL Server : . SQL Server 2000 9 9 . . , .
. . , . , , . , . , , , , , .
:
- SQL Server;
|
|
- SQL Server;
- Windows NT;
- Windows NT, .
, , , .
public. , , . , . , . guest, public , SQL Server. public , master, tempdb, msdb, model, .
. SQL Server . , , SQL Server.
. , SQL Server Windows NT . , . , , .
. . Transact-SQL .
, , , . . SQL Server .
SQL Server.
, . .
. SQL Server 2000, . , . . , , . , , .
. , SQL Server . , . , . .
SQL Server :
- , ;
- SQL Server ;
- , ( , , . .).
SQL Server . , . , .
|
|
, , , .
, , . . .
SQL Server .
. SQL Server, , , (), , .
SQL Server :
- ;
- Transact-SQL;
- ().
, public. , , .
, . . , . , . .
. , , Windows NT SQL Server. .
. , . , , , . , , SELECT, INSERT, UPDATE DELETE . , , INSERT ( ). EXECUTE - .
:
- SELECT, INSERT, UPDATE, DELETE, REFERENCES - ;
- SELECT UPDATE ;
- INSERT DELETE ;
- EXECUTE , .
- REFERENCES - . , . REFERENCES , . , . REFERENCES SQL Server.
|
|
, , . . , , , , .
GRANT, .
, . SQL Server, Windows NT, .
Transact-SQL. , .
. . . .
, . , , . , , , . , .
.
, , : , .
DENY.
GRANT. CASCADE , , .
REVOKE, :
REVOKE [GRANT OPTION FOR]
{ALL | PRIVLEGES}
<_>
.
, GRANT DENY. GRANT OPTION FOR , , WITH GRANT OPTION GRANT. , .
.
. , , . , . .
SQL Server , , , . , . , .