Limiting Table Access
Date: Tue, 16 Mar 2004 15:43:53 GMT
Message-ID: <ZgF5c.67363$Up2.26791_at_pd7tw1no>
Hi, I am hoping someone could point me in the right direction.
I am creating a adhoc site which will allow remote users to view and create
reports from our database.
All the users data is mixed together and is stored in single tables, I have
found that I can create a View Table for each User in order to limit them
My problem is all the SQL statments created for the adhoc site are spefic
to a user. Not very portable.
I have thought of using the SYNONYMS command but this seem to require each
user having there own Login/Password setup to the Oracle database. I am
trying to do this all though one Login/Password to the database.
It seems I need a method to redefine the View Names during a connection only.
Any help will be appreciated. Received on Tue Mar 16 2004 - 16:43:53 CET