Posts

Showing posts from January, 2021

WhatsApp New Policy Impact

Image
WhatsApp New Privacy Policy Impact About WhatsApp WhatsApp sounds like "what's up" is a way to ask someone “what’s going on”. This was a revolutionary application founded by Brian Acton and Jan Koum back in 2009 with the aim to provide free communication (text/voice) via the mobile app over the internet without Ads and maintaining the high degree of data privacy of the users through data encryption. Later, Facebook acquired WhatsApp in Feb 2014. The New Privacy Policy The new policy essentially takes away the choice users had until now to not share their data with other Facebook-owned and third-party apps. WhatsApp users need to provide their consent, failing which they will not be able to use this social messaging app after that. After accepting the terms by a user, Facebook will now use such data for commercial activities to grow their business. Data Security Issues Below are some of the data security issues as per the new privacy policy- 1.The contact details of a use...

MySQL DB Procedure Execution by a non-root user

Image
In my this blog, I'll share my experience of one of the issues that I faced during procedures execution for a migration project Problem Statement Recently I have been involved in an application migration project from one cloud to another cloud. I have done the database migration and due to security reasons, I have changed the identifier of all procedures to a non-root use so that I don't need to provide root credentials. However, One strange issue encountered during the procedure execution. Below is the sample snippet of my procedure I have been executing with a non-root user- CALL save_wallet_request('233284','23342sad','1','2021-01-13 06:54:23','eeedewewqewqeqe',@out_pgref_no,@out_dup_err)     Error Code: 1449. The user specified as a definer ('root'@'%') does not exist   0.107 sec Although I have a valid identifier in my procedure i.e. 'user001@%' but still I was not able to execute the procedure. Cause The proc...