Re: When is a stored procedure needed?
From: joel garry <joel-garry_at_home.com>
Date: Wed, 6 May 2009 09:28:12 -0700 (PDT)
Message-ID: <7dc73345-b54f-4528-bca6-c4f82e1bfd37_at_x31g2000prc.googlegroups.com>
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.
Date: Wed, 6 May 2009 09:28:12 -0700 (PDT)
Message-ID: <7dc73345-b54f-4528-bca6-c4f82e1bfd37_at_x31g2000prc.googlegroups.com>
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
-- _at_home.com is bogus. "There were shockingly few epic battle scenes in the Harold and Kumar movies." - John Cho, radio interview, talking about Sulu swordwork.Received on Wed May 06 2009 - 11:28:12 CDT