Re: When is a stored procedure needed?
From: Mladen Gogala <gogala.mladen_at_bogus.email.com>
Date: Thu, 7 May 2009 06:02:29 +0000 (UTC)
Message-ID: <gttthl$87u$1_at_solani.org>
Na Wed, 06 May 2009 09:28:12 -0700, joel garry napisao:
>
> Viewers don't pay, advertisers pay for viewers hitrates. There's a
> whole industry built around this, sucking advertising revenue from
> traditional media, causing newspapers to shut down or be eviscerated,
> among other things. Nothing wrong with that per se (unless you consider
> it insidiously evil by definition, or are troubled by the downward
> quality pressure on journalism, or like newspapers), but in our case it
> is taking our volunteer good works and giving money to greedy people who
> add no value. I'm offended by that, just as I would be if I wrote a
> paper or book or song and someone stole it and published it as theirs.
>
> jg
Date: Thu, 7 May 2009 06:02:29 +0000 (UTC)
Message-ID: <gttthl$87u$1_at_solani.org>
Na Wed, 06 May 2009 09:28:12 -0700, joel garry napisao:
> On May 6, 6:11 am, Michael Austin <maus..._at_firstdbasource.com> wrote:
>> joel garry wrote: >> > On May 3, 12:22 am, William Robertson <williamr2..._at_googlemail.com> >> > wrote: >> >> On May 2, 6:39 am, Phper <hi.steven..._at_gmail.com> wrote: >> >> >>> Is it suggestible to write a stored procedure for registering or >> >>> sign- in? >> >> Obviously a database connection will need to be established in order >> >> for any procedure stored in the database to be accessible to the >> >> user, so you would have to connect first to some generic account in >> >> order to call it. Then there is the problem that PL/SQL can't >> >> reconnect you as another user, although it could issue an ALTER >> >> SESSION to change the default schema, or enable some roles, or >> >> change some global variables you might use to identify application >> >> users. It all depends on what you are trying to do, how you define >> >> user accounts, how you want the login/register process to work, what >> >> the front end application is written in etc, hence the replies >> >> above. >> >> > I have come to believe this person is using this and other volunteer >> > resources to collect information and then post it as his own for >> > profit. Check posting history. Please feed the troll garbage. >> >> > jg >> > -- >> > _at_home.com is bogus. >> >http://www.google.com/search?hl=en&q=%22yellow+rambler%22+%22black+bm...
>> >> anyone that pays these sites for information you can get for free on >> the myriads of reputable sites deserves what they get.
>
> Viewers don't pay, advertisers pay for viewers hitrates. There's a
> whole industry built around this, sucking advertising revenue from
> traditional media, causing newspapers to shut down or be eviscerated,
> among other things. Nothing wrong with that per se (unless you consider
> it insidiously evil by definition, or are troubled by the downward
> quality pressure on journalism, or like newspapers), but in our case it
> is taking our volunteer good works and giving money to greedy people who
> add no value. I'm offended by that, just as I would be if I wrote a
> paper or book or song and someone stole it and published it as theirs.
>
> jg
I am not offended, I just want my cut.
-- http://mgogala.freehostia.comReceived on Thu May 07 2009 - 01:02:29 CDT