Results 1 to 3 of 3

Thread: CREATE VIEW command denied to user

  1. #1
    spsoftware is offline Junior Member
    Join Date
    Nov 2019
    Posts
    2

    Default CREATE VIEW command denied to user

    hey there,
    There is something wrong when I use SQL via phpMyAdmin:
    Code:
    -- --------------
    CREATE ALGORITHM=UNDEFINED DEFINER=`my_spsoftware`@`localhost` SQL SECURITY DEFINER VIEW `vmp_vw_products`  AS  select `p1`.`id` AS `id`,`p1`.`parentid` AS `parentid`,`p1`.`name` AS `name`,`p1`.`snattrs` AS `snattrs`,`p1`.`active` AS `active`,if(isnull(`p1`.`parentid`),`p1`.`algorithm`,`p2`.`algorithm`) AS `algorithm`,if(isnull(`p1`.`parentid`),`p1`.`bits`,`p2`.`bits`) AS `bits`,if(isnull(`p1`.`parentid`),`p1`.`uses_act`,`p2`.`uses_act`) AS `uses_act`,if(isnull(`p1`.`parentid`),`p1`.`act_pattern`,`p2`.`act_pattern`) AS `act_pattern`,if(isnull(`p1`.`parentid`),`p1`.`act_extracount`,`p2`.`act_extracount`) AS `act_extracount`,if(isnull(`p1`.`parentid`),`p1`.`name`,concat(`p2`.`name`,' - ',`p1`.`name`)) AS `fullname`,if(isnull(`p1`.`parentid`),`p1`.`product_code`,`p2`.`product_code`) AS `product_code`,if(isnull(`p1`.`parentid`),`p1`.`public_exp`,`p2`.`public_exp`) AS `public_exp`,if(isnull(`p1`.`parentid`),`p1`.`private_exp`,`p2`.`private_exp`) AS `private_exp`,if(isnull(`p1`.`parentid`),`p1`.`modulus`,`p2`.`modulus`) AS `modulus` from (`vmp_products` `p1` left join `vmp_products` `p2` on((`p1`.`parentid` = `p2`.`id`))) ;
    -- --------------
    Here's some error messages:
    -------------
    MySQL said: Documentation

    #1142 - CREATE VIEW command denied to user 'spsoftware'@'localhost' for table 'vmp_vw_products'
    ----------------
    I've google it and google says "GRANT CREATE VIEW ON *.* TO 'username'@'host'; " can fix it.
    but I used this SQL from phpMyAdmin, also Access denied.
    any ideas?

  2. #2
    alemoppo is offline AlterVista Staff
    Join Date
    Feb 2010
    Location
    IT
    Posts
    678

    Default

    I'm sorry but the Views are not supported on AlterVista.

    Bye!

  3. #3
    spsoftware is offline Junior Member
    Join Date
    Nov 2019
    Posts
    2

    Default

    Thanks,I'll use other methods instead it.
    Bye!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

SEO by vBSEO