On Sat, 01 Nov 2003 22:41:00 GMT, "M Simpson" <no***@nowhere.com>
wrote:
If you are doing C++, ADO and ODBC can do this. I agree that you are
probably doing something wrong if you are doing this. I've seen people use
this construct before and it usually places an unneeded restriction on you.
I have to do it inside a stored procedure. Depending on user who
executes that procedure, it will return all just some of the
attributes.
The procedure also does some math on some restricted attributes
returning all or just a part of them. In case of lowest sec.level
user, it will return the tuple without those restricted attributes.
It also must work for all tables (it receives tablename as argument).
So, the client application will receive from database already filtered
data. That is why I must do this inside a SP.
Mario.