Quellcode View nmv_v1_insert

[ Überblick   Tabellen  Views  Prozeduren  Trigger  nmv_v1_insert ]

Das DB-Objekt selbst

create view "demoadm".nmv_v1_insert (nmv_nmvid,nmv_uniqname,nmv_name,nmv_kurz,nmv_text) as
  select x0.nmv_nmvid ,x0.nmv_uniqname ,x0.nmv_name ,x0.nmv_kurz
    ,x0.nmv_text from "demoadm".numverw x0 ;

Abhängige Objekte, Rechte

grant update on "demoadm".nmv_v1_insert to "agus" as "demoadm";
grant insert on "demoadm".nmv_v1_insert to "agus" as "demoadm";
grant delete on "demoadm".nmv_v1_insert to "agus" as "demoadm";
grant update on "demoadm".nmv_v1_insert to "bastian" as "demoadm";
grant insert on "demoadm".nmv_v1_insert to "bastian" as "demoadm";
grant delete on "demoadm".nmv_v1_insert to "bastian" as "demoadm";
grant update on "demoadm".nmv_v1_insert to "dbadmin" as "demoadm";
grant insert on "demoadm".nmv_v1_insert to "dbadmin" as "demoadm";
grant delete on "demoadm".nmv_v1_insert to "dbadmin" as "demoadm";
grant update on "demoadm".nmv_v1_insert to "joachim" as "demoadm";
grant insert on "demoadm".nmv_v1_insert to "joachim" as "demoadm";
grant delete on "demoadm".nmv_v1_insert to "joachim" as "demoadm";
grant select on "demoadm".nmv_v1_insert to "public" as "demoadm";
grant update on "demoadm".nmv_v1_insert to "rohloff" as "demoadm";
grant insert on "demoadm".nmv_v1_insert to "rohloff" as "demoadm";
grant delete on "demoadm".nmv_v1_insert to "rohloff" as "demoadm";
grant update on "demoadm".nmv_v1_insert to "troschke" as "demoadm";
grant insert on "demoadm".nmv_v1_insert to "troschke" as "demoadm";
grant delete on "demoadm".nmv_v1_insert to "troschke" as "demoadm";
grant update on "demoadm".nmv_v1_insert to "wapa" as "demoadm";
grant insert on "demoadm".nmv_v1_insert to "wapa" as "demoadm";
grant delete on "demoadm".nmv_v1_insert to "wapa" as "demoadm";

HTML-Autor: Rohloff, Datenbank: demodb, Datenstand: 31.05.00 17:07