WHY SUPER PRIVILEGES ??

[Vinay KD]

Hi,
I am using MySql on Windows XP SP2,
And MySQL Administrator GUI Tool for manipulating the database.

I created a database "testdatabase" from root login.

I created a user "testuser" and set all the privileges to it.

Then i logged to "testuser" and started to restore a database file "testdatabase.sql" which was created on another system for "testdatabase" under root.

I opened the file in a texteditor and replaced all "root" with "testuser"

at the time of restoring at my system it is creating all the tables but when it restores the Views or stored procedures it raises the following error :

Error while executing this query:CREATE DEFINER=`testuser`@`localhost` PROCEDURE `sp_browsebyctg`()
BEGIN
Select * from disp_browsebyctg;
END $$
The server has returned this error message:Access denied; you need the SUPER privilege for this operation
MySQL Error.


Please help me what should i do ???