MySQL Forums
Forum List  »  Security

Re: Column info is available when a column is secured
Posted by: KimSeong Loh
Date: April 25, 2005 09:27PM

Are you using the `test` database in your testing?
I found that the privileges is not enforced when the database name is `test`.
Maybe someone can explain this.

Works well with another database with a different name. SELECT * will fail if you do not have SELECT priv on all the columns/

You can see the tables and database you have access to, and all columns when you do a DESC.
But, tables and database which you do not have any access at all is not listed.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Column info is available when a column is secured
2876
April 25, 2005 09:27PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.