grant all privileges on test.* to test@'222.122.20.173' identified by '?????'; //173번서버에서 접속권한.. 

grant all privileges on test.* to test@222.122.20.162 identified by '?????'; //162번서버에서 접속권한.. 

grant all privileges on test.* to test@localhost identified by '?????'; //로컬에서의 접속권한.. 

grant all privileges on test.* to test@222.122.20.171 identified by '?????'; 

현재 저희가 이런식으로 권한을 주고있는데요.. 

grant all select on test.* to test@'%' identified by '?????'; 이렇게주면

select권한만 준다는건데 어디에서든 접속가능하다는거잖아요...? 

grant all privileges on test.* to test@'222.122.20.173' identified by '?????'; //173번서버에서 접속권한.. 

grant all privileges on test.* to test@222.122.20.162 identified by '?????'; //162번서버에서 접속권한.. 

grant all privileges on test.* to test@localhost identified by '?????'; //로컬에서의 접속권한.. 

grant all privileges on test.* to test@222.122.20.171 identified by '?????'; 

grant all select on test.* to test@'%' identified by '?????'; 

이렇게 모두한번에 주게 될경우 173,162,171,로컬인경우는 모든권한을 가지게되고 그외 다른곳에서 접속햇을때는

select권한만 가지는게 맞는건가요?