proc sql;
   connect to oracle as tempdb
           (user=student pw=sesame path=temppath
            connection=global);
   select *
      from connection to tempdb
              (select ssn, lname, fname, activity
                  from members 
                  where contacts<5);
   (grant update on members
                      to student) by tempdb;
   ...
quit;