Oracle, show tables as username.table_name and sort by owner, tablename

[GoogleCodeExporter]

If you use an oracle dsn which has dba access, you get a lot of tables back

It would make life easier if the tables where listed as owner.table_name
and sorted by owner then table_name as well

Original issue reported on code.google.com by zac.spit...@gmail.com on 11 May 2007 at 5:08

[GoogleCodeExporter]

Actually it is bad practise to use a dsn with dba access. You _should_ use a 
dsn with
a restricted user that has access to only one schema. 

But, I think it would be better to only list the tables of that user's schema. I
already modified the Oracle CFC accordingly and submitted that change to Brian.

Chris

Original comment by cfl...@gmail.com on 25 Jul 2007 at 12:49

[GoogleCodeExporter]

I agree that schema access should be controlled via the DSN. But, that being 
said,
listing the schemas available through that DSN is a feature that could be 
helpful.
I'm not listed as a contributor. But, if you need this functionality now, check 
out
this quick update:
http://www.codescraps.com/blog/index.cfm/2008/4/23/Illudium-PU36-Code-Generator-
with-Oracle-Schemas

Original comment by philhul...@gmail.com on 23 Apr 2008 at 9:22

[GoogleCodeExporter]

I believe this is corrected in the bleeding edge release in svn. I committed the
changes sent by Phil which lists schema.table and sorts by owner and table name.
Please resubmit if this issue recurs.

Original comment by brian.ri...@gmail.com on 28 Apr 2008 at 1:04

• Changed state: Fixed