On Thursday 16 January 2003 09:15, Addison Ellis wrote:
> how can i view privileges for a table in a db?
There is no command to see privileges on the certain table/db etc.
If you have privileges on database 'mysql' you can search through tables to
see privileges.
--
For technical s
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 perfor
hello,
how can i view privileges for a table in a db? thank you, addison
sql,query,queries,smallint
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
[EMAIL PROTECTED]
[EMAIL PROTECTED]
subsidiaries of small independent publishing co.
[EMA
