2 questions on MySQL privileges# Database - 数据库
M*r
1 楼
1. It seems if
grant all on db1.* to 'abc'@'%' identified by 'abc'
then, if I only want to revoke select from one table
revoke select on db1.tbl1 from 'abc'@'%'
it doesn't work?
2. If I drop an object (e.g. table), will the privileges granted to it be
dropped automatically?
Some old readings refer to these issue in 3.x/4.x days, have them been fixed on
5.0.x(seem doesn't work on 5.0.51a)? or will they be fixed later?
grant all on db1.* to 'abc'@'%' identified by 'abc'
then, if I only want to revoke select from one table
revoke select on db1.tbl1 from 'abc'@'%'
it doesn't work?
2. If I drop an object (e.g. table), will the privileges granted to it be
dropped automatically?
Some old readings refer to these issue in 3.x/4.x days, have them been fixed on
5.0.x(seem doesn't work on 5.0.51a)? or will they be fixed later?