| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:End-user DDL?
Rich,
As I stated in a previous post, we've got that GOD forsaken tool running around here as well. Now Access is capable of doing it's own DDL in Oracle, but I would not allow it since you get all of these object names with spaces & case sensitivity in them. Basically to access them from outside Access you have to enclose all of the table and column names in double quotes. So, what do I do? Well first I don't allow the end users to process their own DDL, a developer has to do that and for the real duhvelepors, I have them send the ddl over here & I run it, after suitable editing. Then they attach to the tables as 'pass thru queries'. It helps although it's not the best solution. Also, if they crash one of their access DB's (and I don't care if it's production or not) I have a good laugh, period.
Simply put, Access is NOT an IS supported tool. Your on your own.
Dick Goulet
____________________Reply Separator____________________ Author: "Jesse; Rich" <Rich.Jesse_at_qtiworld.com> Date: 5/11/2001 1:11 PM
So, there I am. An Oracle DBA with a host of MS Access databases that end-users have created to do reporting via linked tables. Fine.
All of a sudden, one of these MS Access databases gets corrupted. Guess what? It was also used to enter and hold production data! Eek!
I would like to create an Oracle DB (8i) and allow the end user to create and manipulate Oracle tables that they can then link to their MS Access queries/forms/reports. It doesn't look that that can be done using MS Access' weak toolset.
We were guessing that we may be able to create a custom Perl CGI to have the end-user do their own DDL on a webpage, but this seems like we might be reinventing the wheel.
Has anyone given end-users (read: know nothing about Oracle) carte blanche access to do their own DDL? What tools did you use?
TIA,
Rich Jesse System/Database Administrator Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri May 11 2001 - 16:03:58 CDT
 |
 |