-
January 28th, 2006, 12:51 PM
#1
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
-
January 29th, 2006, 04:35 AM
#2
Re: MySql & SP
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
Can you help me with my homework assignment?, Before you post!, Use code tags, How to post!, Codeguru technical FAQs, C++ FAQ Lite, Stroustrup: C++ Style and Technique FAQ, Guru of the Week, Comeau C and C++ FAQs, Comeau C++ Templates FAQs, CUJ @ DDJ, Spam threshold
My Blogs : Learning C++ is fun | Abnegator's reflections
Open Threads : C++ Aha! Moments | Nature of work in C++?
-
January 29th, 2006, 05:08 AM
#3
Re: MySql & SP
ok so how can i give a authorization to a proc table?
-
January 30th, 2006, 05:14 AM
#4
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|