Questions tagged with Amazon Relational Database Service
Content language: English
Sort by most recent
Hi,
Im getting this strange error:
```
ERROR 1227 (42000): Access denied; you need (at least one of) the GRANT OPTION privilege(s) for this operation
```
Trying to run this command on "writer instance" of "multi-az cluster":
```
grant replication slave, replication client, replication_slave_admin on *.* to 'repl'@'%';
```
Knowing that the same command works on the "multi-az" "writer instance", im confused.
Hi,
Logged on as the m aster user on a Oracle 19 RDS database, I would like to execute the following:
GRANT EXECUTE ON XDB.DBMS_XMLSCHEMA TO appl_owner;
This fails with ORA-01031: insufficient privileges.
I tried this with RDSADMIN package:
EXECUTE rdsadmin.rdsadmin_util.**grant_sys_object**( p_obj_name=>'DBMS_XMLSCHEMA', p_grantee=>'FWD_OWNER', p_privilege=>'EXECUTE');
But that want to grant privileges on SYS objects, so it doesn't find objects in schema XDB.
How can I grant privileges on objects in different schema (xdb) to o different user/schema?
Thanks
I want to make some database operations with GUI and what is the best option for this project? To run my project i'm using xampp and I would like to be able to run queries on my database and dynamically display, sort, add, remove, and update records based on site user input. Should I use a RDS database or EC2?
Hello AWS,
I have a Client requirement to create a USER and Grant ALL PRIVILEGES to this newly created USER. These SQL Queries are working on my on-premises Oracle Database but when executing the same in AWS's Oracle RDS instance, the Query is not working for my newly created user it shows the privileges error! I'm unable to give ALL PRIVILEDGES for newly created USER in RDS. Have pasted and attached the following queries and the Error faced.
alter session set "_ORACLE_SCRIPT"=true;
create user mendix_so_8_10 identified by 1;
GRANT ALL PRIVILEGES TO mendix_so_8_10;
Kindly Requesting your team to give us a working solution to our problem. Awaiting your reply at the earliest.
Thanks & Regards,
Madhumitha. B
Someone deleted rows from the critical table of RDS Aurora MySQL Instance. We don't have anything in slow query log either. Is there any other way to find out or trace all the query that ran against RDS aurora Instances?
In doing some performance testing in a non-prod environment, I'd like to temporarily increase the instance size to get a baseline number. If I do this, how difficult is it to reduce the instance size in order to keep costs low?
Hello,
I want to implement "active-active" replication, like it is described here https://workmarket.tech/zero-downtime-maintenances-on-mysql-rds-ba13b51103c2 , but using multi-az feature created read instances/replicas. As far as i understood, if im using just "multi-az" then i dont have access to the created "secondary" database. In "multi-az cluster" and "aurora cluster", i do have "read" access to the "secondary" database replicas. Is it possible to get "cmd" access into them? Is it possible to implement some manual changes with cmd access? Is it possible to get the "binlog" location, and using it, setup the "active-active" replication, between the "primary" and "standby"? Or there are some limitations, that make it impossible?
Thanks
I'm newbie to AWS. When I looked at my Bill today, the RDS Backup services were the cause of the rise in the bill.
There isn't a database,nor snapshots or anything operating at the RDS Dashboard, only the standard mysql:80.
How can I terminate the RDS Backup Services?
All my instances,services,rds snapshots are deleted still there is increase in my bill.
We recently upgraded an MSSQL RDS database instance from 12.00.6329.1.v1 to 15.00.4236.7.v1. The instance functions fine, but it is supporting a legacy application that sometimes encounters errors that leave us no choice but to rollback to a snapshot. We also copy snapshots to our QA account periodically to refresh our QA databases, and this procedure has increased by the same significant amount of time. Prior to upgrading, these snapshot restores took around 30 minutes to get the instance to the Available state. After upgrading, it is taking several hours. The most recent attempt took 6 hours. This is harmful to our business as the increase in recovery time causes cascading effects. This feels like a possible AWS bug, I'm not sure what we could possibly do differently to improve this outcome. Any ideas?
Instance details:
Instance class: db.r6i.4xlarge
Storage type: gp2
Storage size: 2000GiB
Where can I find the listener logs for AWS RDS Oracle databases. I can only find alert logs and audit logs in the AWS console but not listener logs
RDS databases have DNS names. The primary DB and read replicas have different DNS names.
1) Does my code need to have access to the read replicas and if yes then in what way?
2)Once I have created my read replicas, is it automatic that my read throughput will be scaled out or does one make other configurations?