Unix Technical Forum

ODBC access: how to restrict the tables view and column detail?

This is a discussion on ODBC access: how to restrict the tables view and column detail? within the pgsql Novice forums, part of the PostgreSQL category; --> My issue: using postgre with odbc for crystal report access. I created a specific user which can read only ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Novice

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 09:54 PM
alain.butzberger@efi.com
 
Posts: n/a
Default ODBC access: how to restrict the tables view and column detail?

My issue: using postgre with odbc for crystal report access. I created
a specific user which can read only one view, which is a compile info
from different tables. When in crystal report editor, using that
restricted user I can view all the data of the view, but data from any
of the table. BUT I can see the name of all the tables existing in this
application, and more then that, I can see all the columns of each of
the tables in this database.

Question: how can I hide the existence of the tables and their design,
(not just prevent data access, which is working fine.)

Remark: using currently psql (PostgreSQL) 7.2.1 and also psql
(PostgreSQL) 8.1.3

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 11:59 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com