Blatt8_Aufgabe2


a)
GRANT USAGE ON SCHEMA mouafi to miller;
b)
GRANT UPDATE , INSERT ON willinagl to miller;
--WITH GRANT OPTION;

c)
GRANT CREATE ON SCHEMA mouafi to miller;

d)
GRANT ALL ON albums to miller
--WITH GRANT OPTION;
e)
REVOKE ALL ON SCHEMA mouafi from miller;
--oder Statt ALL, einzelne Rechte eingeben.

f)
GRANT SELECT
ON songs_view
to GROUP infosys WITH GRANT OPTION;

g)
REVOKE SELECT
ON songs_view
FROM GROUP infosys;

h)
REFERENCES

i)
REVOKE SELECT
ON songs_view
from GROUP infosys;

j)

REVOKE USAGE ON SCHEMA mouafi from mansmann;

k)
REVOKE UPDATE ON albums FROM mouafi;

l)

GRANT SELECT
ON songs_view
to GROUP infosys WITH GRANT OPTION;