"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
We have to login as admin user
exceute below commands
EXEC rdsadmin.rdsadmin_util.rename_global_name(p_new_global_name => 'new_global_name');
##### 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
Error: invalid value for name (must only contain alphanumeric characters, hyphens, underscores, commas, periods, @ symbols, plus and equals signs)
Solutions : please check data type in associtaed variable block
main.tf
provider "aws" {
region = "us-east-1"
}
resource "aws_security_group" "allow_ssh" {
name = "allow_ssh_oracle_mssql_port"
description = "allow_ssh_oracle_mssql_port "
ingress {
description = "ssh-port"
from_port = 22
to_port = 22
protocol = "tcp"
cidr_blocks = [var.my_ip]
}
ingress {
description = "Oracle-port "
from_port = 1521
to_port = 1521
protocol = "tcp"
cidr_blocks = [var.my_ip]
}
ingress {
description = "MSSQL-Port"
from_port = 1433
to_port = 1433
protocol = "tcp"
cidr_blocks = [var.my_ip]
}
egress {
from_port = 0
to_port = 0
protocol = "-1"
cidr_blocks = ["0.0.0.0/0"]
#ipv6_cidr_blocks = [var.my_ip]
}
tags = {
Name = "allow_imp_port_Oracle_MSSQL_ssh"
}
}
variables.tf
variable "my_ip" {
default = "34.207.6.67/32"
}
Terraform commands
terraform init
terraform plan
terraform apply
test_output.tf
provider "aws" {
region = "us-east-1"
}
resource "aws_eip" "eip1" {
domain = "vpc"
}
output "My_Public_ip" {
value = aws_eip.eip1.public_ip
}
Terraform commands
terraform init
terraform plan
terraform apply
