> 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]
