, , Rodriguez? ID ? , DBA , CONNECT.
, IDENTIFIED BY, . , , ID . DBA , ,
GRANT CONNECT TO Thelonius IDENTIFIED BY Redwagon;
Thelonius, , Redwagon, .
Thelonious , DBA Redwagon. , . , , . , REVOKE CONNECT, "" . , .
CONNECT , . , DBA . ( ), RESOURCE. .
CONNECT , , , , . , , CONNECT. , , , INSERT, . RESOURSE; CONNECT, .
, . , .
SQL, , SQL. , , , DBA . , .
SQL , SQL . GRANT : . WITH GRANT OPTION , .
|
|
, , , . , , SQL, .
23 SQL, , , , , , .
SQL
Janet .
Stephan .
INSERT () Claire .
Jerry 100 500.
Janet , .
(. A .)
SQL
SQL, , , , , . , , .
, , , , SQL , . , SQL ( ANSI).
. , , , ( ) , , , . ( .)
Adrian Clients, Diane.Customers, CREATE SYNONYM :
CREATE SYNONYM clients FOR Diane.Customers;
, Adrian Clients , Diane.Customers. Clients , Adrian.