436
правок
Изменения
Предваритльно: синтаксис для удаления и добавления прав
= Data Control Language =
== Добавление прав ==
<font color=blue>grant <font color=red>{<font color=blue>select<font color=grey>|<font color=blue>insert<font color=grey>|<font color=blue>update<font color=grey>|<font color=blue>delete<font color=grey>|<font color=blue>create<font color=grey>|<font color=blue>execute<font color=grey>|<font color=blue>trigger<font color=grey>|<font color=blue>usage<font color=grey>|<font color=red>…<font color=grey>|<font color=blue>all priviledges<font color=red>}</font>
<font color=blue>on <font color=red>{<font color=blue>table<font color=grey>|<font color=blue>database<font color=grey>|<font color=blue>view<font color=grey>|<font color=blue>procedure<font color=grey>|<font color=blue>function<font color=grey>|<font color=red>…} имя</font>
<font color=blue>to <font color=red>{пользователь<font color=grey>|<font color=blue>group <font color=red>группа<font color=grey>|<font color=blue>public<font color=red>}</font>
<font color=red>[<font color=blue>with grant option<font color=red>]<font color=blacj>
=== Примеры ===
<font color=blue>grant all priviledges on <font color=black>Students</font>
<font color=blue> to group <font color=black>Deans <font color=blue>with grant option<font color=grey>;<font color=black>
<font color=blue>grant select on <font color=black>Students <font color=blue>to public<font color=grey>;<font color=black>
== Удаление прав ==
<font color=blue>revoke <font color=red>[<font color=blue>grant option for<font color=red>]</font>
<font color=red>{<font color=blue>select<font color=grey>|<font color=blue>insert<font color=grey>|<font color=blue>update<font color=grey>|<font color=blue>delete<font color=grey>|<font color=blue>create<font color=grey>|<font color=blue>execute<font color=grey>|<font color=blue>trigger<font color=grey>|<font color=blue>usage<font color=grey>|<font color=red>…<font color=grey>|<font color=blue>all priviledges<font color=red>}</font>
<font color=blue>on <font color=red>{<font color=blue>table<font color=grey>|<font color=blue>database<font color=grey>|<font color=blue>view<font color=grey>|<font color=blue>procedure<font color=grey>|<font color=blue>function<font color=grey>|<font color=red>…} имя</font>
<font color=blue>from <font color=red>{пользователь<font color=grey>|<font color=blue>group <font color=red>группа<font color=grey>|<font color=blue>public<font color=red>}</font>
<font color=red>[<font color=blue>cascade<font color=grey>|<font color=blue>restrict<font color=red>]<font color=black>
=== Примеры ===
<font color=blue>revoke insert on <font color=black>Students</font>
<font color=blue> from group <font color=black>Deans <font color=blue>cascade<font color=grey>;<font color=black>
<font color=blue>revoke update on <font color=black>Students <font color=blue>from public<font color=grey>;<font color=black>
== Владелец объекта ==
text
= Представления и права =
