sql - GRANT user with select clause -

have 2 tables : applicant , applies

//applicant a# ------------- 1 2 3 4   5  //applies a#           position --------------------- 1              gm 2             ceo 3             director 3             manager 

so create user this:

create user test identified testing; grant create session test; 

now want grant select test on table applicant have @ least 1 record in applies table using follow query:

select a.a#,count(a.a#) applicant    inner join applies ap on a.a#=ap.a#    having count(a.a#)>0 group a.a#; 

how grant user test? select clause condition

grant select on applicant (select.......) test; 

fail work, errors come out.