Re: ODBC first time odbc - Mailing list pgsql-odbc

<p><font color="#000000"><font size="2"><font face="arial,sans-serif"></font></font></font> <p><font face="Arial"
size="2">Okay,</font><p><font face="Arial" size="2"></font> <p><font face="Arial" size="2">   You may want to start at
theindex and read the manual.   </font><p><font face="Arial" size="2"></font> <p><font face="Arial" size="2">    But I
thinkyou need to "grant select ................" to your ODBC user for your permissions issue.</font><p><font
face="Arial"size="2"></font> <p><font face="Arial" size="2">    <a
href="http://www.postgresql.org/docs/9.0/static/sql-grant.html">http://www.postgresql.org/docs/9.0/static/sql-grant.html</a></font><p><font
face="Arial"size="2"></font> <p><font face="Arial" size="2">    JMS.. </font><p><font color="#000000"><font
size="2"><fontface="arial,sans-serif"></font></font></font> <p><font color="#000000"><font size="2"><font
face="arial,sans-serif"> </font></font></font><p><br/><blockquote style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT:
5px;MARGIN-LEFT: 0px">-----Original Message----- <br />From: Marc Fromm <br />Sent: Mar 29, 2011 5:13 PM <br />To:
"pgsql-odbc@postgresql.org"<br />Subject: [ODBC] ODBC first time odbc <br /><br /><style><ZZZ!-- 
/* Font Definitions */
@font-face{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal,
div.MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri","sans-serif";}
a:ZZZlink, span.MsoHyperlink{mso-style-priority:99;color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed{mso-style-priority:99;color:purple;text-decoration:underline;}
p{mso-style-priority:99;margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate{mso-style-priority:99;mso-style-link:"Balloon Text
Char";margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma","sans-serif";}
span.EmailStyle18{mso-style-type:personal;font-family:"Calibri","sans-serif";color:windowtext;}
span.EmailStyle19{mso-style-type:personal;font-family:"Calibri","sans-serif";color:#1F497D;}
span.EmailStyle20{mso-style-type:personal-reply;font-family:"Calibri","sans-serif";color:#1F497D;}
span.BalloonTextChar{mso-style-name:"Balloon Text Char";mso-style-priority:99;mso-style-link:"Balloon
Text";font-family:"Tahoma","sans-serif";}
.MsoChpDefault{mso-style-type:export-only;font-size:10.0pt;}
@page WordSection1{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1{page:WordSection1;}
--></style><div class="WordSection1"><p class="MsoNormal"><span style="COLOR: #1f497d">By changing the user that I
loginwith to a super user, everything works. I don’t get the permission denied error.</span><p class="MsoNormal"><span
style="COLOR:#1f497d">However, I only want the users to read. Being set as a super user allows the odbc user to change
thedata.</span><p class="MsoNormal"><span style="COLOR: #1f497d"> </span><p class="MsoNormal"><span style="COLOR:
#1f497d">Myproblem is now down to two security points:</span><p class="MsoNormal"><span style="COLOR: #1f497d">How do I
havea user with only read access (not a super user) and not be denied viewing the table data?</span><p
class="MsoNormal"><spanstyle="COLOR: #1f497d"> </span><p class="MsoNormal"><span style="COLOR: #1f497d">How do I
controlaccess with listen_address=’localhost, specific.ip.addresses’ and not use ‘*’?</span><p class="MsoNormal"><span
style="COLOR:#1f497d">Setting listen_address=’localhost, specific.ip.addresses’ does not work, I get call failed errors
askingif the server is accepting tcp/ip connections on port 5432</span><p class="MsoNormal"><span style="COLOR:
#1f497d"> </span><pclass="MsoNormal"><span style="COLOR: #1f497d">Thanks</span><p class="MsoNormal"><span style="COLOR:
#1f497d"> </span><pclass="MsoNormal"><span style="COLOR: #1f497d"> </span><div><div style="BORDER-BOTTOM: medium none;
BORDER-LEFT:medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid;
BORDER-RIGHT:medium none; PADDING-TOP: 3pt"><p class="MsoNormal"><b><span style="FONT-FAMILY: 'Tahoma','sans-serif';
FONT-SIZE:10pt">From:</span></b><span style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"> Marc Fromm <br
/><b>Sent:</b>Tuesday, March 29, 2011 1:23 PM<br /><b>To:</b> 'jsilberberg@mindspring.com'<br /><b>Cc:</b>
pgsql-odbc@postgresql.org<br/><b>Subject:</b> RE: [ODBC] first time odbc</span></div></div><p class="MsoNormal"> <p
class="MsoNormal"><spanstyle="COLOR: #1f497d">By editing postgresql.conf and changing listen_address = ‘*’ and editing
pg_hba.confand adding host all all my.ip.address allowed me to connect to the postgresql data base with Microsoft
access.</span><p class="MsoNormal"><span style="COLOR: #1f497d"> </span><p class="MsoNormal"><span style="COLOR:
#1f497d">Inaccess I can see the table and it fields, but if I try to use the table in a querry or view the table I get
anerror: permission denied for relation summer_finaid; error while executing the query (#7)</span><p
class="MsoNormal"><spanstyle="COLOR: #1f497d"> </span><p class="MsoNormal"><span style="COLOR: #1f497d">Any
ideas?</span><pclass="MsoNormal"><span style="COLOR: #1f497d"> </span><p class="MsoNormal"><span style="COLOR:
#1f497d">Alsoin the postgresql instead of listen_address=’*’ I tried listen_address=’localhost, my.ip.address’ but that
failedto work.</span><p class="MsoNormal"><span style="COLOR: #1f497d">How can I keep local host and only allow
specificaddress? I don’t want to open it up to all with ‘*’</span><p class="MsoNormal"><span style="COLOR:
#1f497d"> </span><pclass="MsoNormal"><span style="COLOR: #1f497d">Thanks</span><p class="MsoNormal"><span style="COLOR:
#1f497d"> </span><pclass="MsoNormal"><span style="COLOR: #1f497d"> </span><div><div style="BORDER-BOTTOM: medium none;
BORDER-LEFT:medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid;
BORDER-RIGHT:medium none; PADDING-TOP: 3pt"><p class="MsoNormal"><b><span style="FONT-FAMILY: 'Tahoma','sans-serif';
FONT-SIZE:10pt">From:</span></b><span style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">
jsilberberg@mindspring.com[mailto:jsilberberg@mindspring.com] <br /><b>Sent:</b> Tuesday, March 29, 2011 11:13 AM<br
/><b>To:</b>Marc Fromm; pgsql-odbc@postgresql.org<br /><b>Subject:</b> Re: [ODBC] first time odbc</span></div></div><p
class="MsoNormal"> <p><spanstyle="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt"> </span><p><span
style="FONT-FAMILY:'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">Why, </span><p><span style="FONT-FAMILY:
'Arial','sans-serif';COLOR: black; FONT-SIZE: 10pt"> </span><p><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR:
black;FONT-SIZE: 10pt">    That's a vintage 02-Feb-2006 driver.</span><p><span style="FONT-FAMILY:
'Arial','sans-serif';COLOR: black; FONT-SIZE: 10pt"> </span><p><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR:
black;FONT-SIZE: 10pt">     I use 8.04 from Dec-2009 and even that's getting a little stale.  Why not try the 9.n
drivers.</span><p><spanstyle="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt"> </span><p><span
style="FONT-FAMILY:'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">     Could the port(s) be blocked / restricted
betweenyou and the server and is PostgreSQL SSL support enabled -- </span><p><span style="FONT-FAMILY:
'Arial','sans-serif';COLOR: black; FONT-SIZE: 10pt">        <a
href="http://www.postgresql.org/docs/9.0/static/ssl-tcp.html"
target="_blank">http://www.postgresql.org/docs/9.0/static/ssl-tcp.html</a></span><p><spanstyle="FONT-FAMILY:
'Arial','sans-serif';COLOR: black; FONT-SIZE: 10pt"> </span><p><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR:
black;FONT-SIZE: 10pt">     JMS</span><p><span style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE:
10pt"> </span><p><spanstyle="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; FONT-SIZE:
10pt">    -----------------------------------</span><p><spanstyle="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black;
FONT-SIZE:10pt"> </span><blockquote style="BORDER-BOTTOM: medium none; BORDER-LEFT: blue 1.5pt solid; PADDING-BOTTOM:
0in;MARGIN-TOP: 5pt; PADDING-LEFT: 4pt; PADDING-RIGHT: 0in; MARGIN-BOTTOM: 5pt; MARGIN-LEFT: 0in; BORDER-TOP: medium
none;BORDER-RIGHT: medium none; PADDING-TOP: 0in"><p class="MsoNormal" style="MARGIN-BOTTOM: 12pt"><span
style="FONT-FAMILY:'Arial','sans-serif'; COLOR: black; FONT-SIZE: 10pt">-----Original Message----- <br />From: Marc
Fromm<br />Sent: Mar 29, 2011 1:58 PM <br />To: "<a href="mailto:pgsql-odbc@postgresql.org"
target="_blank">pgsql-odbc@postgresql.org</a>"<br />Subject: [ODBC] first time odbc <br /><br /></span><p
class="MsoNormal"><spanstyle="COLOR: black">Before learning there was an odbc list, I sent this post to the admin
list.</span><pclass="MsoNormal"><span style="COLOR: black"> </span><p class="MsoNormal"><span style="COLOR: black">I am
runningpostgres on a red hat linux server.</span><p class="MsoNormal"><span style="COLOR:
black">postgresql-python-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR:
black">postgresql-test-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR:
black">postgresql-libs-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR:
black">postgresql-docs-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR:
black">postgresql-contrib-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR:
black">postgresql-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR:
black">postgresql-pl-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><b><span style="COLOR:
black">postgresql-odbc-08.01.0200-3.1</span></b><spanstyle="COLOR: black"></span><p class="MsoNormal"><span
style="COLOR:black">postgresql-jdbc-8.1.407-1jpp.4</span><p class="MsoNormal"><span style="COLOR:
black">postgresql-server-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR:
black">postgresql-tcl-8.1.23-1.el5_6.1</span><pclass="MsoNormal"><span style="COLOR: black"> </span><p
class="MsoNormal"><spanstyle="COLOR: black">User on windows computers would like to odbc to the postgres
databases.</span><pclass="MsoNormal"><span style="COLOR: black">I downloaded the windows postgres odbc drivers from the
followingsite and installed version “psqlodbc-08_01_0200” on the windows computer.</span><p class="MsoNormal"><span
style="COLOR:black"><a href="http://ftp9.us.postgresql.org/pub/mirrors/postgresql/odbc/versions/msi/"
target="_blank">http://ftp9.us.postgresql.org/pub/mirrors/postgresql/odbc/versions/msi/</a></span><p
class="MsoNormal"><spanstyle="COLOR: black"> </span><p class="MsoNormal"><span style="COLOR: black">When I configure a
“FileData Source” connection in access, I cannot connect to the postgresql database. I get the message, “A connection
couldnot be made using the file data source parameters entered. Save non-verified file DSN?”</span><p
class="MsoNormal"><spanstyle="COLOR: black">The parameters entered are:</span><p class="MsoNormal"><span style="COLOR:
black">Database:database_name</span><p class="MsoNormal"><span style="COLOR: black">Server: I entered the IP address of
theserver</span><p class="MsoNormal"><span style="COLOR: black">User Name: I entered postgres</span><p
class="MsoNormal"><spanstyle="COLOR: black">Password:</span><p class="MsoNormal"><span style="COLOR: black">SSL Mode:
prefer</span><pclass="MsoNormal"><span style="COLOR: black">Port: 5432 (which is the port used by postgres)</span><p
class="MsoNormal"><spanstyle="COLOR: black"> </span><p class="MsoNormal"><span style="COLOR: black">Do I need to
configurethe /etc/odbc.ini file? It is currently just a blank file.</span><p class="MsoNormal"><span style="COLOR:
black"> </span><pclass="MsoNormal"><span style="COLOR: black">Thanks for any help.</span><p class="MsoNormal"><span
style="COLOR:black"> </span><p class="MsoNormal"><span style="FONT-FAMILY: 'Courier New'; COLOR: black; FONT-SIZE:
10pt">Marc</span><spanstyle="COLOR: black"></span></blockquote></div></blockquote>