MySQL Forums
Forum List  »  Views

Re: Granting a view to a view
Posted by: Ed Wiles
Date: September 29, 2010 02:43AM

Hi Glenn,

Thanks for this. I presume that's the SQL SECURITY DEFINER/INVOKER clause in CREATE VIEW. If you don't specify it (as in the script above), then it's DEFINER by default. You can see this by typing "SHOW CREATE VIEW test2_view".

So unfortunately I don't think it's the problem in this case.

Thanks again

Ed

Options: ReplyQuote


Subject
Views
Written By
Posted
3361
September 20, 2010 09:04AM
1481
September 21, 2010 09:19AM
1538
September 22, 2010 01:33AM
1463
September 28, 2010 04:30PM
2481
September 29, 2010 02:40AM
Re: Granting a view to a view
1638
September 29, 2010 02:43AM


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.