Click to See Complete Forum and Search --> : MySql & SP


ppl1
January 28th, 2006, 12:51 PM
how can i give a authorization to a proc table?
i wrote-

mysql> GRANT all
-> ON proc
-> TO Admin@localhost
-> IDENTIFIED BY xyz;


but i guess its wrong...

the proc table exist in the system , right? i dont need to create it?
how can i see all the sp in the proc table (MySql 5)?
thanks in advanced

exterminator
January 29th, 2006, 04:35 AM
the proc table exist in the system , right? i dont need to create it? how can i see all the sp in the proc table (MySql 5)?
information_schema.routines (http://dev.mysql.com/doc/refman/5.0/en/routines-table.html)

ppl1
January 29th, 2006, 05:08 AM
ok so how can i give a authorization to a proc table?

ppl1
January 30th, 2006, 05:14 AM
nevermind...i get that