MySQL Forums
Forum List  »  Security

granting execute rights
Posted by: Jod75
Date: August 09, 2005 03:07AM

Hi,

I'm finding a difficulty in granting a particular user execute rights for stored procedures only. I don't want the user to access tables directly so he must have only access to sprocs. This is what I am doing:

grant usage mydb.* to 'test1'@'localhost';
grant execute on procedure sproc1 to 'test1'@'localhost';

I can logon with the user but not access mydb, ie the command "use mydb" will return an access denied message.

Any suggestions what I might be doing wrong?

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
granting execute rights
5181
August 09, 2005 03:07AM
2197
August 09, 2005 07:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.