Page 1 of 1

Can't Create View in mySQL

Posted: Sun Aug 26, 2012 10:56 pm
by guru13
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.

Re: Can't Create View in mySQL

Posted: Sun Aug 26, 2012 11:32 pm
by HashiniA
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

Re: Can't Create View in mySQL

Posted: Sun Aug 26, 2012 11:45 pm
by guru13
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
Hi Hashini,

I haven't received any email.

Regards.

Re: Can't Create View in mySQL

Posted: Sun Aug 26, 2012 11:51 pm
by kushanw
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.

Re: Can't Create View in mySQL

Posted: Mon Aug 27, 2012 12:10 am
by kushanw
Hi Guru,

I have resend the email. Please check.

Re: Can't Create View in mySQL

Posted: Mon Aug 27, 2012 12:15 am
by guru13
I have received the email and have sent the reply.

Re: Can't Create View in mySQL

Posted: Tue Sep 23, 2014 11:08 pm
by guru13
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

Posted: Tue Sep 23, 2014 11:27 pm
by ShaminG
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.
I will have this discussed with our sysadmins and provide you an update.

Re: Can't Create View in mySQL

Posted: Wed Sep 24, 2014 10:04 am
by shoner
guru13 wrote: Can I be granted access to the SHOW VIEW command please?

Thanks.
This has now been fixed. Can you please check and confirm.

Re: Can't Create View in mySQL

Posted: Wed Sep 24, 2014 11:22 pm
by guru13
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.

Re: Can't Create View in mySQL

Posted: Wed Sep 24, 2014 11:39 pm
by LodumS
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.
Hi,

We will advise our system engineers to further investigate this issue.

Regards

Re: Can't Create View in mySQL

Posted: Wed Sep 24, 2014 11:59 pm
by guru13
LodumS wrote:
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.
Hi,

We will advise our system engineers to further investigate this issue.

Regards
That is not the issue, I can create views. The issue I get is as below:

#1142 - SHOW VIEW command denied to user 'fwdbu9669'@'localhost' for table 'all_scores_v'

Re: Can't Create View in mySQL

Posted: Thu Sep 25, 2014 12:09 am
by LodumS
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.
Hi,

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

Posted: Fri Sep 26, 2014 12:56 pm
by angelos
LodumS wrote: Any way we have forwarded the correct error message to our system engineers. We will update you soon.
Could you try again and let us know how it goes?