Doug,
First off, have you considered the greenplum forums for these sorts of
questions?
> 1. What permissions are required to use the server status
Superuser. Since you get to see other people's queries.
> 2. Is there any workaround if that permission is superuser.
Have a superuser create a SECURITY DEFINER function on the master.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com