Can't Create View in mySQL
Can't Create View in mySQL
Hi,
I have a mySQL database and I have created tables. However I want to create some views (so I don't have to type in long and tedious queries). However when I enter a CREATE VIEW statement I get back:
#1142 - CREATE VIEW command denied to user 'fwdbu9669'@'localhost' for table 'some_v'
Can I get permissions to create Views?
Thanks.
I have a mySQL database and I have created tables. However I want to create some views (so I don't have to type in long and tedious queries). However when I enter a CREATE VIEW statement I get back:
#1142 - CREATE VIEW command denied to user 'fwdbu9669'@'localhost' for table 'some_v'
Can I get permissions to create Views?
Thanks.
Re: Can't Create View in mySQL
Hello Guru,
We have created a ticket for your request as we need few details from your end. Could you please reply back to that email.
Regards,
Hashini
We have created a ticket for your request as we need few details from your end. Could you please reply back to that email.
Regards,
Hashini
Re: Can't Create View in mySQL
Hi Hashini,HashiniA wrote:Hello Guru,
We have created a ticket for your request as we need few details from your end. Could you please reply back to that email.
Regards,
Hashini
I haven't received any email.
Regards.
Re: Can't Create View in mySQL
Hi Guru,
We have sent you an email with the ticket reference 5543771 to the nominated email address given in your account. If you did not receive this email, please PM me your correct email address.
We have sent you an email with the ticket reference 5543771 to the nominated email address given in your account. If you did not receive this email, please PM me your correct email address.
Re: Can't Create View in mySQL
Hi Guru,
I have resend the email. Please check.
I have resend the email. Please check.
Re: Can't Create View in mySQL
I have received the email and have sent the reply.
Re: Can't Create View in mySQL
Hi,
I am trying to backup my mySQL database which contains views however I get the following error for each of my views:
#1142 - SHOW VIEW command denied to user 'fwdbu9669'@'localhost' for table 'some_view'
Can I be granted access to the SHOW VIEW command please?
Thanks.
I am trying to backup my mySQL database which contains views however I get the following error for each of my views:
#1142 - SHOW VIEW command denied to user 'fwdbu9669'@'localhost' for table 'some_view'
Can I be granted access to the SHOW VIEW command please?
Thanks.
Re: Can't Create View in mySQL
I will have this discussed with our sysadmins and provide you an update.guru13 wrote:Hi,
I am trying to backup my mySQL database which contains views however I get the following error for each of my views:
#1142 - SHOW VIEW command denied to user 'fwdbu9669'@'localhost' for table 'some_view'
Can I be granted access to the SHOW VIEW command please?
Thanks.
Re: Can't Create View in mySQL
This has now been fixed. Can you please check and confirm.guru13 wrote: Can I be granted access to the SHOW VIEW command please?
Thanks.
"Helping Making a Better World"
Log a fault ticket Here
or call Exetel VOIP numbers (02) 8030 1000 or 1300 788 141 (log faults 24x7)
Exetel Support Portal
Log a fault ticket Here
or call Exetel VOIP numbers (02) 8030 1000 or 1300 788 141 (log faults 24x7)
Exetel Support Portal
Re: Can't Create View in mySQL
Hi,
I checked but I still get errors when performing an Export from mydbadmin:
--
-- Structure for view `all_scores_v`
--
DROP TABLE IF EXISTS `all_scores_v`;
-- in use(#1142 - SHOW VIEW command denied to user 'fwdbu9669'@'localhost' for table 'all_scores_v')
Cheers.
I checked but I still get errors when performing an Export from mydbadmin:
--
-- Structure for view `all_scores_v`
--
DROP TABLE IF EXISTS `all_scores_v`;
-- in use(#1142 - SHOW VIEW command denied to user 'fwdbu9669'@'localhost' for table 'all_scores_v')
Cheers.
Re: Can't Create View in mySQL
Hi,guru13 wrote:Hi,
I have a mySQL database and I have created tables. However I want to create some views (so I don't have to type in long and tedious queries). However when I enter a CREATE VIEW statement I get back:
#1142 - CREATE VIEW command denied to user 'fwdbu9669'@'localhost' for table 'some_v'
Can I get permissions to create Views?
Thanks.
We will advise our system engineers to further investigate this issue.
Regards
Re: Can't Create View in mySQL
That is not the issue, I can create views. The issue I get is as below:LodumS wrote:Hi,guru13 wrote:Hi,
I have a mySQL database and I have created tables. However I want to create some views (so I don't have to type in long and tedious queries). However when I enter a CREATE VIEW statement I get back:
#1142 - CREATE VIEW command denied to user 'fwdbu9669'@'localhost' for table 'some_v'
Can I get permissions to create Views?
Thanks.
We will advise our system engineers to further investigate this issue.
Regards
#1142 - SHOW VIEW command denied to user 'fwdbu9669'@'localhost' for table 'all_scores_v'
Re: Can't Create View in mySQL
Hi,guru13 wrote:Hi,
I have a mySQL database and I have created tables. However I want to create some views (so I don't have to type in long and tedious queries). However when I enter a CREATE VIEW statement I get back:
#1142 - CREATE VIEW command denied to user 'fwdbu9669'@'localhost' for table 'some_v'
Can I get permissions to create Views?
Thanks.
Sorry about that, I have quoted the wrong post.
Any way we have forwarded the correct error message to our system engineers. We will update you soon.
Regards
Re: Can't Create View in mySQL
Could you try again and let us know how it goes?LodumS wrote: Any way we have forwarded the correct error message to our system engineers. We will update you soon.