使用show effective grants查看权限
1、问题描述用户showgrants显示只有连接权限,但该用户却能执行sbtest.下的所有操作GreatSQL>\s...Serverversion:8.0.3224GreatSQL,Release24,Revision3714067bc8c...GreatSQL>showgrants;++Grantsforuser1172.%++GRANTUSAGEON.TOuser1172.%++1rowinset(0.00sec)GreatSQL>selectfromsbtest.sbtest1limit1;+++++idkcpad+++++12505073942347759896895752911215503342507137131003454727381253072726761288302500348844794...