Can't Create View in mySQL

[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.

[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

[guru13]

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.

[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.

[kushanw]

Hi Guru,

I have resend the email. Please check.

[guru13]

I have received the email and have sent the reply.

[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.

[ShaminG]

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.

[shoner]

Can I be granted access to the SHOW VIEW command please?

Thanks.

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

[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.

[LodumS]

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

[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.

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'

[LodumS]

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

[angelos]

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?