Skip to content
  • Home
  • Database
    • Oracle
    • MySQL/MariaDB
    • PostgreSQL
    • SQL Server
    • MS Access
  • & More
    • Cloud Computing
    • WordPress
    • Task Logger
  • About Me
Facebook Linkedin YouTube

Kaysar Iqbal

DBA – MySQL, PostgreSQL, MongoDB, Oracle

Tag: mysql

Grant SELECT on MySQL tables except a few tables

February 14, 2017June 22, 2017Mohammad Kaysar Iqbal TalukdarLeave a comment

Task: Grant SELECT access on tables in vos3000db schema except a few tables (which contains user credentials  and security information) to another newly created MySQL user which will be used by billing department. Connection to MySQL server will only be allowed from billing application server. Each day a new table is creating in MySQL vos3000db schema.…

Read More

Search posts

Tags Cloud

AWS (2) CentOS (1) cloud computing (1) EC2 (2) error (3) FusionCloud (1) installation (2) Linux (1) ms access (5) mysql (1) OCI-22303 (1) OpenStack (1) opiodr (1) ORA-04031 (1) ORA-609 (1) oracle (7) oracle11g (1) ospid (1) software eng. (2) sql server (2) tutorial (10) UDE-22303 (1) Uncategorised (2) unix (1) windows (1) wordpress (3) বাংলা টিউটোরিয়াল (1)

Recent Posts

  • PostgreSQL 13 logical replication configuration January 12, 2022
  • PostgreSQL 13 stream replication configuration using rsync in Linux January 11, 2022
  • PostgreSQL 13 log shipping replication configuration using rsync in Linux January 10, 2022
  • MySQL 8.0 table level replication in Windows December 1, 2021
  • Installing MySQL on CentOS linux using the MySQL yum repository January 5, 2021
  • ORA-01031: insufficient privileges raised during materialized view creation on another schema December 1, 2020
  • [ERROR] mariadbd: Out of sort memory November 28, 2020
  • Detected table cache mutex contention at instance 1: 60% waits. Additional table cache instance activated. Number of instances after activation: 2. November 27, 2020
  • Obtain DDL scripts for MariaDB/MySQL schema objects November 25, 2020
  • Obtain DDL scripts for oracle schema objects November 25, 2020
  • MySQL Replication on CentOs 7: Configure binary log file position based replication (Fresh server with no data) November 24, 2020
  • ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled November 23, 2020
  • ORA-39142: incompatible version number 5.1 in dump file October 11, 2020
  • Implement purging of table data by dropping partitions automatically October 1, 2020
  • Interval partitioning in oracle October 1, 2020
  • Connect to MariaDB from Oracle and perform DML on remote MariaDB table March 12, 2020
  • ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_**** March 1, 2020
  • Install and configure MariaDB Galera 4 cluster on Centos 7 in VirtualBox February 18, 2020
  • Oracle table partitioning: why, when and how October 16, 2019
  • Migrating Bitnami WordPress website from AWS EC2 to VPS Bitnami NGINX September 30, 2019

Older Posts

My Facebook Page

My Facebook Page
© 2023 Kaysar Iqbal | WordPress Theme: Nucleare by CrestaProject.