In reply to Eren.

Eren,

You could use metadata permissions in SAS Management Console to manage the tables/views that are registered in each library, but that would be a manual process to update. Each time you added a table or view you would need to update the library metadata. And your EG users would have to access the libraries with the META engine, and not the native SAS/ACCESS to Greenplum approach.

If it's a matter of providing better navigation, you might be able to point users to the ability to see more details about their library contents. That view will allow users to see which items are views vs. tables.

Other than that, unless there is a way in a SAS LIBNAME statement to tell SAS/ACCESS to Greenplum to "mask" either tables or views (I don't think so), I can't think of a simple approach.