oraUserServer is a macro that determines with what user and on which Oracle database server a libref is connected to. %macro oraUserServer(oraLib);
proc sql;
connect using &oraLib;
select * from connection to &oraLib (
select user, global_name from global_name
)
quit;
%mend oraUserServer;