Hiding Objects from ODBC Query

Поиск
Список
Период
Сортировка
От Raymond
Тема Hiding Objects from ODBC Query
Дата
Msg-id 200308161151.26347.support@bigriverinfotech.com
обсуждение исходный текст
Список pgsql-general
Success with a fairly complex M$ Access database port ( if anything from
Access could be considered complex) to Postgres 7.3.4 on RH80.

Utilizes views, constraints, RI, triggers, PL/pgSQL functions, indices,
sequences, rules, groups, etc. The whole 9 yards.

Postgres is indeed a marvelous ORDB platform and development environment.
(would like to a little better java and python function support and examples
so I get away from #$@^& pl/sql :-)

Access clients tunnel via Windoz ssh client to a localhost'd Postgres daemon;
client connectivity is via current ODBC connector.

Client will be subsequently migrated to EJB-JSP or PHP in the near future.

Everything is great EXCEPT:

I cannot conceal system and other database objects that the end user does not
directly access. Database was configured for end users to utilize virtual
objects (views, with insert, update and delete privileges utilizing the
rewrite engine). While the end user cannot directly interact with other
database objects, he or she can view most all system and database relation
attributes and properties utilizing any ODBC query tool!!!

Help in concealing system and database objects please!

Raymond



В списке pgsql-general по дате отправления:

Предыдущее
От: "HansH"
Дата:
Сообщение: Re: Dreamweaver
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: dump_all/restore times?