rajeshkumar created the topic: ERROR 1227 (42000) at line 133: Access denied; you need the SUPER priv

ERROR 1227 (42000) at line 133: Access denied; you need the SUPER privilege for this operation
SQL query:
DELIMITER ; ;

/*!50003 CREATE*//*!50017 DEFINER=`s_snetus`@`localhost`*//*!50003 TRIGGER `inserttree` AFTER INSERT ON `account_owner` FOR EACH ROW BEGIN DECLARE s INTEGER; DECLARE t INTEGER; DECLARE ParentPath varchar(30); SET s=NEW.REPORTS_TO; SET t = NEW.ID; if s is NULL then insert into hierarchy_path values (t,t); else select PATH INTO ParentPath from hierarchy_path where ID = s; insert into hierarchy_path values (t,CONCAT(ParentPath,’,’,t)); end if; END */ ; ;
MySQL said:
#1227 – Access denied; you need the SUPER privilege for this operation
Regards,
Rajesh Kumar
Twitt me @ twitter.com/RajeshKumarIn

Rajesh Kumar

I’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I am working at Cotocus. I blog tech insights at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at I reviewed , and SEO strategies at Wizbrand. 

Please find my social handles as below;

Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at PINTEREST
Rajesh Kumar at QUORA
Rajesh Kumar at WIZBRAND