"ORA-00942 : table or view does not exist. " on synonym

"ORA-00942- table or view does not exist" error you are getting , this indicate that user1 does not have privileges on the user.test table (get the details from synonyms SQL which tables are included ) .

We need to grant that required privileges 

SQL> GRANT SELECT, INSERT, UPDATE, DELETE 

     ON USER.TEST 

     TO USER1;

Note : Create dynamic sql to refersh the privelige if multiple tables and schema included 

How to chnage the global name of a database in AWS oracle RDS ?

 

We have to login as admin user 

exceute below commands 

EXEC rdsadmin.rdsadmin_util.rename_global_name(p_new_global_name => 'new_global_name');

What is Git ?

 

• Git is created by Linus Torvalds in 2005

• Git is the distributed version control system. This stored all version properly  and documented very well 

• Git has ability to track of changes to content and provide mechanisms for sharing the content with other in team

• This is open-source and free software

• Available for multiple platforms (Linux, Unix, Mac, Windows )

• Active community and more than 70%  developer used 

remote-exec Provisioner in terraform

 ##### remote-exec Provisioner demo

resource "aws_instance" "dev-instance" {

  ami           = "ami-05548f9cecf47b442"

  instance_type = "t2.micro"

  key_name = "pgsql_key"

  

  connection {

    type = "ssh"

    user = "ec2-user"

    private_key = file("./pgsql_key.pem")

    host = self.public_ip

  }

  provisioner "remote-exec" {

    inline = [ 

        "sudo yum install -y mysql*"

     ]

    

  }

}

Note: we can use existing key or generate new key