Newsgroups: comp.databases.oracle.misc Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!logbridge.uoregon.edu!news.maxwell.syr.edu!newspeer.radix.net!news.er.usgs.gov!news From: Brian Peasland Subject: Re: "View" to a large schema X-Nntp-Posting-Host: edcxpw014.cr.usgs.gov Content-Type: text/plain; charset=us-ascii Message-ID: <3F09B080.F346E7F@remove_spam.peasland.com> Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA X-Accept-Language: en References: <7ed5e93a.0307070757.39afe0f5@posting.google.com> Mime-Version: 1.0 Date: Mon, 7 Jul 2003 17:40:16 GMT X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U) Lines: 48 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:129102 You can set up a new user (or schema) for just the podiatrists. Then, grant SELECT or whatever privileges they need to this new user. Sign on as that user and they will only be able to see the objects they have privs to. HTH, Brian Hypermommy wrote: > > Hi all, > > You'll have to forgive me if I don't use the right terms. I am > nowhere near an Oracle programmer and don't know the proper > termanology. But I hope you'll bear with me.... > > Something I'm working on accesses an Oracle database we have at the > office. Now this database has hundreds tables in one area (schema?) > and we can't change that. However, the program that's accessing it > (which is an ASP thing) is timing out. And I suspect it's due to the > number of tables and such that is there becuase it works fine with > smaller databases. > > So, now, my issue is... what can we do in Oracle, without splitting up > this schema, to pull over references to just a few tables at a time. > For instance, if we have 10 tables that deal with podiatrists and > that's all we want to look at is podiatrists and not all of the > pediatricians and so forth, is there some way -- without moving the > tables themselves -- to set up a view just to the podiatrist type > information? Then I could set up an ODBC connection to that view > (whatever it is or however it's done) and see just podiatrist > information without the system trying to slog through all the doctors? > > Thanks in advance for whatever assistance you can give me. > > --== Hyper ==-- -- =================================================================== Brian Peasland oracle_dba@remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"