Mysql privilege: does "select" allow me to join

After I changed my privileges to just select, this query ceased to function:

SELECT
         base_SalesTable.*
               ,buckets.width
               ,buckets.teeth
                FROM
base_SalesTable LEFT OUTER JOIN buckets ON base_SalesTable.name = buckets.name WHERE base_SalesTable.category = :category AND base_SalesTable.mincap = :mincap ORDER by weight

Happy Holidays

oh… and one of those tables are a view …

define “ceased to function”

and i think you answered your own question, didn’t you

:slight_smile: