 |
Create View Denied |
 |
Member Login
Welcome
Welcome to the Zymic webmaster forums. Our forums are here to provide people the free ability to discuss a range of websites related topics such as design, development coding and marketing.
In order to post you will need to register for a zymic account or if you already have one simply login by using the form on the left.
 |
Zymic Webmaster Forums Zymic Free Web HostingDatabases & MySQL |
 |
  |
 Jan 7 2012, 09:57 AM
Post
#1
|
|
|
Newbie  Group: Members Posts: 3 Joined: 7-January 12 Member No.: 224,677  |
Hi everyone!
I wanted to create a view in MySQL, but it complained with "CREATE VIEW command denied to user 'XXX'@'XXX' for table 'XXX'". When I created the user and added the permissions, the permission for VIEWS was checked in "Assign privileges", but in "Revoke privileges" the permission are shown as: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES. So no VIEWS in the list. What can I do? Best regards, |
 |
 
|
|
Jan 7 2012, 07:25 PM
Post
#2
|
|
 THE SILENT FORUM NINJA Group: Administrators Posts: 3,758 Joined: 23-January 10 From: on your screen Member No.: 127,507 |
you can come to our livechat at http://livechat.zymic.com/hosting and request it
|
|
|
|
| |
|
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users) |
|
| 0 Members: | ||
|
Forum Jump |
|
| Lo-Fi Version | Time is now: 19th June 2013 - 06:48 AM |