How do I perform common DBA tasks for Amazon RDS DB instances?

Short description

Because Amazon RDS delivers a managed service experience, it doesn't provide shell access to DB instances. For this reason, Amazon RDS restricts access to certain system procedures and tables that require advanced privileges. See the following examples of some common tasks that you can't use standard commands to run in Amazon RDS:

• Bringing a database online when you use Amazon RDS for SQL Server.
• Dropping a DB in a mirrored instance when you use Amazon RDS for SQL Server.
• Stopping an active session or query when you use Amazon RDS for MySQL, Amazon Aurora MySQL-Compatible Edition, or Amazon RDS for MariaDB.
• Switching online log files when you use Amazon RDS for Oracle.

Resolution

If you receive a permission or privilege error message when you run a command or modify a DB instance, then see the following engine-specific resources:

• Administering your Oracle DB instance
• Common DBA tasks for MySQL DB instances
• Amazon RDS for MariaDB
• Common DBA tasks for Microsoft SQL Server
• Common DBA tasks for PostgreSQL

Related information

Getting started with Amazon RDS