Minimal Privileges for MySQL Database Backup Cron Jobhttps://joellipman.com/articles/linux/cpanel/minimal-privileges-for-mysql-database-backup-cron-job.html

20 March 2019 the contents to a copy of the database accessible only by root and and this database "backuper" user. For both methods, I grant the following to the user doing the backup on the database I want a backup of: GRANT SELECT, LOCK TABLES, EVENT, INDEX,...

• Type: Article
• Author: Joel Lipman
• Category: cPanel
• Language: *

Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html

03 April 2009 Source. The Corresponding Source for a work in source code form is that same work. 2. Basic Permissions. All rights granted under this License are granted for the term of copyright on the Program, and are irrevocable provided the stated conditions are...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 the signed document to the Deal record. How? The following is the process from registering the app to call on the full API (grant code > refresh token > access token) and then the code to attach the document to the CRM record. STEP 1: REGISTER A NEW...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 Stored Procedure I already wrote an article on this so please refer to SSRS Parameters in Oracle Stored Procedure. Oracle: Grant another user permissions /* on the table: ssrs_audit_table */ CREATE OR REPLACE PUBLIC SYNONYM ssrs_audit_table FOR...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 = "https://www.zoho.com/books"; // can be any endpoint that does not redirect or reformat the resulting URL // // get Grant Token v_EndPoint = "https://accounts.zoho.com/oauth/v2/auth"; v_Scope =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

GDPR Privacy Policyhttps://joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 be affiliated with, connected to, or sponsored by JoelLipman.com or its subsidiaries. License and Site Access JoelLipman.com grants you a limited license to access and make personal use of this site and not to download (other than page caching) or...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Returning Oracle Stored Procedure Resultset in SSRShttps://joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ssrs.html

19 January 2012 SQL scripts with backups of your datasets, each of these will need tweaking. Create your stored procedure in Oracle (and grant execute for your SSRS user) Add a data source to your SSRS report Add an SSRS input parameter Add a dataset Query type: Stored...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Migrate MediaWiki to another serverhttps://joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

23 September 2009 on document root New Server: create database wikidb; this is inside mysql, Note that both mysql versions should be same. grant create, select, insert, update, delete, lock tables on wikidb.* to wiki@localhost identified by 'YourPassword' ; MediaWiki...

• Type: Article
• Author: Joel Lipman
• Category: MediaWiki
• Language: en-GB

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 tables, etc. This allows broader compatibility and customers who do not have DBAs to run this themselves. Personally I grant the user who will be executing the script full privileges or at least the same as needed to install Joomla CMS. Cross your...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Basic Oracle Stored Procedure Structurehttps://joellipman.com/articles/database/pl-sql/basic-oracle-stored-procedure-structure.html

16 January 2012 Permissions CREATE PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR base_table_owner.sp_get_studentdetails_from_ad; GRANT EXECUTE ON sp_get_studentdetails_from_ad TO a_more_casual_user; Yay for me So this is the basic Oracle stored procedure. Now to...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

DataJumble - Shuffling characters in a data valuehttps://joellipman.com/articles/database/t-sql/data-shuffling-function.html

01 August 2012 AS SELECT RAND() as RandomValue; GO The Function Again you need permission to create this function. Don't forget to GRANT permission to execute this function for whatever user/system account that will run it. -- Drop the function if it already exists IF...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Google Authentication - OAuth 2.0 using PHP/cURLhttps://joellipman.com/articles/google/google-authentication-oauth-2-0-using-php-curl.html

31 October 2018 . urlencode($CLIENT_ID) . '&client_secret=' . urlencode($CLIENT_SECRET) . '&redirect_uri=' . urlencode($REDIRECT_URI) . '&grant_type=authorization_code'; $ch = curl_init(); curl_setopt($ch, CURLOPT_POSTFIELDS, $post_fields); curl_setopt($ch,...

• Type: Article
• Author: Joel Lipman
• Category: Google
• Language: en-GB

Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge-setup-an-api-connection-for-invokeurl.html

12 August 2020 with an underscore. eg. "the_joel_lipman_app" Authentication Type: set this to "oauth2" Param Type: set this to "Header" Grant Type: set this to "Authorization Code" Client ID: Copy & paste from the previous step this value into this field. Client...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 - Setting up custom domain for the customer portal Zoho Creator - Verify custom domain of the customer portal Zoho Creator - Grant Edit Access cPanel Docs - Zone Editor Crazy Domains (UK) - How to Add and Update CNAME Records 123 Reg - How do I set up a...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 m_Headers.put("Authorization","Basic " + v_Base64Auth); m_Params = Map(); m_Params.put("grant_type","refresh_token"); m_Params.put("refresh_token",r_Api.Refresh_Token); m_Params.put("scope",r_Api.Scope_s); r_eBayResponse = invokeurl [ url...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 Location ID (Single Line) API Version (Single Line) Location Code (Origin) (Single Line) Authorize Endpoint (Single Line) Grant URL (Url) Token Endpoint (Single Line) Session ID (Single Line) Redirect URI (Single Line) Scope(s) (Multi Line) Access Token...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge: Connect to Shopifyhttps://joellipman.com/articles/crm/zoho/zoho-deluge-connect-to-shopify.html

15 July 2025 article exists because I spent 2 hours going down the rabbit hole of trying to use OAuth2 and following the usual steps: Grant Code, Refresh Token, Access Token. I also went down the rabbit hole of installing app-bridge and configuring a JWT which was...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *