SELECT * from mysql.tables_priv where Table_name = 'myTable'; You will probably have to log on as 'root' unless you have created another user with the same privileges.
The mysql GRANTs system is used to control USER privileges. This means that for a given table you can view which users can perform what operations on that table. The same holds true of databases and columns within tables. If you have never issued table-specific GRANT statements, then there will be no entries in the mysql.tables_priv table. That is because you have been granting database-wide access to all table functions (Select, Insert, Update, Delete, Create, Drop, Grant, References, Index, Alter) for all users. This is not a good idea. If you want to find out to which users you have been granting all these table-wide privileges, look at the mysql.db table, SELECT * from mysql.db where db='mydb'; The above is a very superficial description of the mysql Access Privilege system. You need to read a lot more in the manual in section 4.2, "General Security Issues and the MySQL Access Privilege System." Doug On Thu, 16 Jan 2003 01:15:03 -0600, Addison Ellis wrote: >hello, > how can i view privileges for a table in a db? thank you, addison >sql,query,queries,smallint >-- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
