(unknown)

This is a multi-part message in MIME format.

------_=_NextPart_001_01CA5808.31BB6810
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

We are moving from Oracle to PostgreSQL and have hit a hitch.

We have a few views that we want to expose to partners at another
institution. However, we do not want them to be able to see the schemas
or even really the names of our other databases. I have found no way to
hide databases and tables from users within a database cluster. It
appears that people have been complaining about not being able to do
this in PG, going a long way back. Is there presently some way to do
this, that I have missed? If not, what approach would you recommend to
accomplish what we want to do here?

I appreciate any help you can give me!

Thomas

(Sent this before I subscribed to the list. It looked like not being
subscribed was holding up the post. I don't mean to spam you with
reposts; sorry for any trouble....)

---

Thomas Houfek

Project Manager, Center for Stem Cell Biology

Vanderbilt University Medical Center

thomas.houfek [at] vanderbilt.edu

(615) 322-9310

------_=_NextPart_001_01CA5808.31BB6810
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/mee tings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/x ml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/di rectory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/20 02/1/alerts/"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/partto part" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/wor kflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsi g-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsi g" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/200 6/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compa tibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/2006/types"=
=
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor talServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

We are moving from Oracle to PostgreSQL and have =
hit a
hitch.<o:p></o:p>

<o:p> </o:p>

We have a few views that we want to expose to =
partners at
another institution. However, we do not want them to be able to =
see the
schemas or even really the names of our other databases. I have =
found no
way to hide databases and tables from users within a database =
cluster. It
appears that people have been complaining about not being able to do =
this in
PG, going a long way back. Is there presently some way to do =
this,
that I have missed? If not, what approach would you =
recommend to
accomplish what we want to do here?<o:p></o:p>

<o:p> </o:p>

I appreciate any help you can give =
me!<o:p></o:p>

<o:p> </o:p>

Thomas<o:p></o:p>

<o:p> </o:p>

(Sent this before I subscribed to the list. =
It looked
like not being subscribed was holding up the post. I don’t =
mean to
spam you with reposts; sorry for any trouble....)<o:p></o:p>

<o:p> </o:p>

---<o:p></o:p>

Thomas Houfek<o:p></o:p>

Project Manager, Center for Stem Cell =
Biology<o:p></o:p>

Vanderbilt University Medical Center<o:p></o:p>

thomas.houfek [at] vanderbilt.edu<o:p></o:p>

(615) 322-9310<o:p></o:p>

<o:p> </o:p>

</div>

</body>

</html>

------_=_NextPart_001_01CA5808.31BB6810--

(unknown)

Re: