IWETHEY v. 0.3.0 | TODO
1,095 registered users | 1 active user | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Theory and Practice of Programming Forum / Re: So where do you hide
Post #157,087
by admin
Picture of admin
5/26/04 4:37:53 PM
Reply
New Re: So where do you hide
Our views are defined in .sql files and loaded by the build system.

Or, with Oracle at least, TOAD or TOra will show you the view definition.

Dunno about NonStop. Seems pretty silly that you can't get the full definition.

So what's so hard about having a complete SELECT statement within a string buffer within the program so that people besides that author can see what's going on?
1) A view is precompiled.
2) A view can have different permissions than the base table.
3) A view can be used with the same built-in logic by more than one program.

No, it isn't "job security".
Regards,

-scott anderson

"Welcome to Rivendell, Mr. Anderson..."
Post #157,178
by lincoln
5/27/04 9:13:20 AM
Reply
New Re: So where do you hide

Dunno about NonStop. Seems pretty silly that you can't get the full definition.

and

3) A view can be used with the same built-in logic by more than one program.

Totally agree with both points.
lincoln
"Windows XP has so many holes in its security that any reasonable user will conclude it was designed by the same German officer who created the prison compound in "Hogan's Heroes." - Andy Ihnatko, Chicago Sun-Times
[link|mailto:bconnors@ev1.net|contact me]
     Time to learn C - (lincoln) - (15) - May 25, 2004, 05:32:57 PM EDT
         Get the K&R book for starters - (ChrisR) - (2) - May 25, 2004, 05:34:48 PM EDT
             Or don't - (deSitter) - (1) - May 25, 2004, 06:26:55 PM EDT
                 Second edition is ANSI C - (ChrisR) - May 25, 2004, 07:00:11 PM EDT
         OT: er... - (admin) - (7) - May 25, 2004, 05:35:49 PM EDT
             So where do you hide - (lincoln) - (6) - May 26, 2004, 02:21:39 PM EDT
                 The view itself is defined in the database - (ChrisR) - May 26, 2004, 02:44:30 PM EDT
                 Re: So where do you hide - (admin) - (1) - May 26, 2004, 04:37:53 PM EDT
                     Re: So where do you hide - (lincoln) - May 27, 2004, 09:13:20 AM EDT
                 this might be useful - (SpiceWare) - (2) - May 26, 2004, 05:45:24 PM EDT
                     The IGM strikes again. -NT - (Another Scott) - May 26, 2004, 08:37:37 PM EDT
                     Good find, but not what I needed - (lincoln) - May 27, 2004, 08:43:07 AM EDT
         Can't you export the view definitions? - (drewk) - (1) - May 25, 2004, 05:35:58 PM EDT
             Depends on the permissions... - (Simon_Jester) - May 25, 2004, 07:03:44 PM EDT
         Dammit - (deSitter) - May 25, 2004, 06:26:18 PM EDT
         Been 20 years - (broomberg) - May 25, 2004, 08:15:01 PM EDT

Let's make a rendezvous.
35 ms