I agree that Ben's article explains this very nicely.  Not sure if this
link works or not:


http://www.sys-con.com/coldfusion/article.cfm?id=705


Kevin.
  _____  

From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 23, 2004 11:36 AM
To: CF-Talk
Subject: Re: Securing CF Apps.


the user/roles are in tables, they are just system tables.

look, i dont want to get into the debate about coding for portability
when it comes to dbs. you should def check out bens article on that one,
as it was well written and he pretty much showed that there is so little
in common between databases that its pretty much impossible, and an
incredible waste of time.

-adam
> -----Original Message-----
> From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 23, 2004 04:28 PM
> To: 'CF-Talk'
> Subject: RE: Securing CF Apps.
>
>  
> > if you caught Ben's article in cfdj a month or two ago, he
> > talks about how you shouldnt be too concerned with
> > portability between databases. Afterall you'll be rewriting
> > all your stored procedures anyway, so reliance on the user's
> > table isn't the breaking point of portability.
>
> You may be rewriting your stored procedures but you may also find
yourself
> reworking your schema as well, not too mention the code that will be
> affected. I can see having different user/passes for select, insert,
update,
> and delete ROLES but I prefer to keep my application roles and
permissions
> in tables. I guess to each his own method.. No one is right or wrong,
just a
> preference thing.
>  
> > sides, how often does a shop really switch between SQL and Oracle?
>
> Not often but it happens.
>
> Mike
>
>
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to