The solution you suggested using a stored procedure seems to be the
most suitable one. User1 creates a procedure (create_view let say)
which expects as a parameter the complete CREATE VIEW statement. Of
course, the procedure will also verify that the provided statements is
indeed a CREATE VIEW command. This procedure should be created with
definer rights and execute privilege should be granted to USER2 user.
In my opinion this is the most direct way to do such a thing.
Regards,
alec.
Received on Wed May 10 2006 - 03:27:13 CDT
