mysql problems

[l0ssrecord]

hi guys hope you can help me with this one. I am trying to figure out how to use the grant priveleges. This is what i did.

grant insert on test.* to sally;


then i logged in using this

mysql -D test -u sally

However, I am still able to do select statements when i only granted insert privelege. Any suggestions?

thnx in advance

[Gary K]

If you were asking some questions on SQL Server 2000 permissions and roles I could probably help you. I'm not familiar with MySql enough to help other than to direct you to dbforums.com (http://dbforums.com/)

[Nephalim]

certain priveleges may automatically be granted to regular users like select, in which case you may need to deny that user the use of select as well. Or there may be a hierarchical level involved with select being needed for insert. I never really had the need to deny just select from a user. See the mysql documentation at mysql.com and find the grant/deny section.