Victoria Reznichenko wrote:
>Sameh,
>Sunday, July 14, 2002, 3:09:53 PM, you wrote:
>
>SA> Can anybody help me figuring how to control granting users
>SA> permissions to created functions in MySQL like we do for SELECT,
INSERT,
>SA> ...etc or it is not possible and every one logged in to MySQL could
>SA> simply use them like any other native function?
>SA> Regards
>
>Take a look at:
> http://www.mysql.com/doc/C/R/CREATE_FUNCTION.html
>
>You must have INSERT and DELETE privileges on the database 'mysql' to
>create and drop functions.
>
>
>
>
>
>
Victoria,
Thanx for your reply. My point is not permiting users to create or
drop functions but mine is:
1 - I need to create certain functions say f1, f2, f3, ... fn
2 - I need to authrorize users using them; i.e. not every user has
the right to run functions from f1 to fn. But user u1 authorised f1 and
f2, user u2 authorised f3 and so on
Regards
Sameh
--
Sameh Attia
Senior System Engineer
T.E. Data
--
__ __ _
_________ _/ /_/ /_(_)___ _
/ ___/ __ `/ __/ __/ / __ `/
(__ ) /_/ / /_/ /_/ / /_/ /
/____/\__,_/\__/\__/_/\__,_/
---------------------------------------------------------------------
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
