When we use grant as following:
GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by
peter;
Then peter can only select the field of col_name_1 on the tbl_name_1 of
db_name_1.
However, when peter issue the query: DESC tbl_name_1; he can see all the
structure of that table.
On Sat, Mar 24, 2001 at 11:22:37PM +0800, Fai wrote:
When we use grant as following:
GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by
"peter";
Then peter can only select the field of col_name_1 on the tbl_name_1 of
db_name_1.
However, when peter issue the query:
When we use grant as following:
GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by
"peter";
Then peter can only select the field of col_name_1 on the tbl_name_1 of
db_name_1.
However, when peter issue the query: DESC tbl_name_1; he can see all the
structure of that table.