MySql & SP

how can i give a authorization to a proc table?
i wrote-

Code:

---

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

Quote:

---

Originally Posted by ppl1

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

ok so how can i give a authorization to a proc table?

nevermind...i get that