: . , , , .
:
- ( ) . . .
- , , , . .
:
- . . , , .
- . . PUBLIC, . , , , PUBLIC.
- (), .
- . . , . , . , . , , , .
- .
- , , , , , . , .
. : ().
|
|
, , . , , , , .
. . .
, .
. , . - , .
, (, Oracle), , .
SQL , , . .
SQL
SQL : GRANT REVOKE .
:
GRANT {< > | ALL PRIVILEGES }
ON <_>
{<_> | PUBLIC }
[WITH GRANT OPTION ]
.
ALL PRIVILEGES , .
<_> : , , , .
<_> PUBLIC , .
WITH GRANT OPTION , , . .
, user1, user2 user3. .
Userl Tab1, . , user2 , Tab1 (, ), user3 , .
|
|
: SELECT, INSERT, DELETE, UPDATE. .
:
GRANT {[SELECT][.INSERT][.DELETE][.UPDATE
(< >)]} ON <_>
TO {<_> | PUBLIC }
[WITH GRANT OPTION ]
:
GRANT INSERT
ON Tab1
TO user2
GRANT SELECT
ON Tab1
TO user3
, user2 Tab1, user3 Tab1.
, . , . , SENA Tab1. user3 :
GRANT SELECT, UPDATE (SENA)
ON Tab1
TO user3
user1 , user4 , Tab1.
GRANT ALL PRIVILEGES
ON Tab1
TO user4
WITH GRANT OPTION
user4 Tab1 user1. user5 :
GRANT INSERT
ON Tab1
TO user5
, , , , , . user4 :
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 }
CASCADE RESTRICT , . CASCADE , GRANT , , , WITH GRANT OPTION.
,
REVOKE ALL PRIVILEGES
ON Tab1
TO user4 CASCADE
user5, user4 .
RESTRICT , REVOKE. ., , :
|
|
REVOKE ALL PRIVILEGES
ON Tab1
TO user4 RESTRICT
, user4 user5.
REVOKE . , PUBLIC.
REVOKE
REVOKE INSERT
ON Tab1
TO user2, user4 CASCADE
, GRANT REVOKE.
, () , PUBLIC.
, REVOKE
REVOKE EXECUTE
ON COUNT_EX
TO PUBLIC CASCADE
user4
GRANT EXECUTE
ON COUNT_EX
TO user4
. :
GRANT CREATE TABLE ALTER TABLE DROP TABLE
ON DB_LIB
TO user1
user1 , DB_LIB, , .
. , MS SQL Server main_user . :
GRANT CREATE DATABASE
ON SERVER_0
TO main_user
main_user, , .
, , . , Oracle , ( ). . , 80 .
, , . . (CREATE TABLE), , CREATE TRIGGER. Oracle , . Oracle , .