* raj
> However, I wish to use this as a security tool. I.e. one in which I (as
> the mysql admin) can do a grant like:
>
> "all queries on a specific table from user "apache" must only return
> 1 record"
>
> This would be like forcing a limit of 1 (using the technique below).
I don't think GRANT
Hi John,
thanks for the limit tip!
However, I wish to use this as a security tool. I.e. one in which I (as
the mysql admin) can do a grant like:
"all queries on a specific table from user "apache" must only return
1 record"
This would be like forcing a limit of 1 (using the technique below).
see if the limit keyword will do what you want.
select * from table limit 0, 2000
> Hi all,
>
> is it possible to limit a result so that only the first record in a query
> can be returned for a specific user?
>
> I want to do this so that someone who does not have intimate knowledge of
> a l
Hi all,
is it possible to limit a result so that only the first record in a query
can be returned for a specific user?
I want to do this so that someone who does not have intimate knowledge of
a large (>10 records) table cannot issue commands to grab *all* of the
data.
Thanks ahead of time f