Database query table all field problem-CodePudding

Why I use ordinary account to connect to the database to perform the following statement
select * from the users. Table_columns

showed no access

but connected display table does not exist on the root account??????? Answer genuflect is begged!!!!!!

CodePudding user response:
When you don't have enough permissions, could not judge is really does not exist, or no permission to see, so are shown as no authority
CodePudding user response:
First determine permission and then to find if there is a table
CodePudding user response:
There should be no permission problems,
CodePudding user response:
reference 1st floor ZJCXC response:
when you don't have enough permissions, could not judge is true does not exist, or no permission to see, so are shown as no permission

Root login account is certainly have permission
There is a table to determine
CodePudding user response:
refer to the second floor rucypli response:
first determines permissions and then to find if there is a table

Root login account is certainly have permission
There is a table to determine