|
in our apps we have a few settings where the user's
access is determined by an sql clause that follows them arround.
for instance if a user was only supposed to have
access to accounts that started with "01.0" the sql clause for that user would
be something like:
and sget(accountno,4,1)='01.0'
right now, we are having to update all the
users' clauses ourselves, but it would be nice to be able to give the users
a way to do this themselves so it was off our plates and on theres.
The problem is that the sql clauses can be pretty
intricate with or's and and's and parenthesis so it's hard to make up an
interface for this, especialy one that would be intelligable to non
programmers.
Has anyone done anything like this before?
Any nice imaginative solutions out there? (:
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf |
- Re: Witango-Talk: building sql clauses Alan Wolfe
