1. As SDE (or sys) user grant privileges to view owner with the “with grant option” through sql:SQL> grant select,insert,update,delete on state_lineages to msd with grant option; Grant succeeded. 2. As owner, Grant select, insert, update, delete on mv view to second user (maxweb) through sql (or sdetable):SQL> grant select,insert,update,delete on cities_view to maxweb; Grant succeeded. 3. As SDE (or sys) user REVOKE privileges from owner granted in step 1 through sql:SQL> revoke select,insert,update,delete on state_lineages from msd; Revoke succeeded.