Karpova_bazy_dannyh

SELECT @DEL_EX = ISBN from deleted

/* , */

EXEC @Ntek = COUNT_EX @DEL_EX

/* , - BOOKS */

IF @Ntek = DELETE from BOOKS WHERE BOQKS ISBN =@DEL_EXEN0GQ

SQL

SQL, , -

SQL. SQL SQL

. SQL. , SQL

.

SQL .

SQL -

. ,

SQL. , SQL

. ,

-

, , . ,

SQL

.

SQL -

EXECUTE IMMEDIATE. -

:

EXECUTE IMMEDIATE <_> SQL .

- , . SQL, -

.

PREPARE, :

PREPARE <_> FROM <_> <_> .

- EXECUTE, :

EXECUTE <_> USING {<> | DESCRIPTOR <_>}

DESCRIPTOR , ,

, .

. SQL2 SQL.

SQL2 :

ALLOCATE DESCRIPTOR <_> [WITH <_>]

-

.

DEALLOCATE DESCRIPTOR <_> - , . -

.

SET DESCRIPTOR {COUNT - <_> | VALUE <-

> {<_ > <_>[...]}} -

.

, , , .

GET DESCRIPTOR {<_ COUNT | VALUE <-

>, {<_>=<_}}-

.

DESCRIBE [INPUT | OUTPUT] <_> USING SQL DESCRIPTOR <_pa> , - (DESCRIBE OUTPUT) (DESCRIBE

.

13

:

. «»,

,

, .

:

-

()

.

.

.

.

277

PUBLIC.

(), .

, .

.

Oracle ,

,

.

SQL ,

-

,

.

.

SQL : GRANT REVOKE -

.

:

GRANT {<_ | AIL PRIVILEGES}

ON <_> {<_> | PUBLIC} [WITH GRANT OPTION ]

.

ALL PRIVILEGES ,

.

<_> : , , , .

<_> PUBLIC , .

:

GRANT {[SELECT] [INSERT] [DELETE] [UPDATE (<_>)]} ON <_>

279

{<_> | PUBLIC} [WITH GRANT OPTION]

:

GRANT INSERT

ON Tab1

TO user2

GRANT SELECT

ON Tab1

TO user3

GRANT SELECT. UPDATE (COST)

ON Tab1

TO user3

user1 , user4 -

,

Tab1.

GRANT ALL PRIVILEGES

ON b1

TO user4

WITH GRANT OPTION

user4

Tab1 user1 . user5,

:

GRANT INSERT

ON b1

user5

GRANT SELECT, UPDATE. DELETE

ON Tab1

TO user4

WITH GRANT OPTION.

user4 user5, .

-

, -

-

.

,

, , ,

SELECT,

, -

4 : SELECT, INSERT, UPDATE DELETE.

SQL - REVOKE. :

REVOKE {< | ALL PRIVILEGES} ON <_>

FROM {<> | PUBLIC} {CASCADE | RESTRICT}

, :

REVOKE ALL PRIVILEGES

ON Tab1

TO user4 CASCADE

281

, user4 - users.

REVOKE

.

,

PUBLIC.

REVOKE: REVOKE INSERT

ON Tab1

TO user2.user4 CASCADE

, -

GRW REVOKE,

, () -

, PUBLIC.

, REVOKE.

REVOKEEXECUTE

ON COUNT_EX

TO PUBLIC CASCADE

user4.

GRANT EXECUTE

ON COUNTJX

TO user4

.

:

GRANT CREATE TABLE. ALTER TABLE, DROP TABLE ON DBJ.IB

TO user1

user1 , DB_LIB,

GRANT CREATE DATABASE

ON SERVER_0

TO main user

.

MS SQL Server