How do I perform common DBA tasks for Amazon Relational Database Service (Amazon RDS)?

Because Amazon RDS delivers a managed service experience, there is no shell access provided to DB instances. For this reason, access to certain system procedures and tables that require advanced privileges are restricted. See the following examples of some common tasks that can't be executed in RDS by using standard commands:

  • Bringing a database online when using RDS for SQL Server.
  • Dropping a DB in a mirrored instance when using RDS for SQL Server.
  • Killing an active session or query when using RDS for MySQL, Aurora MySQL, or MariaDB.
  • Switching online log files when using RDS for Oracle.

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

Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center.

Published: 2015-11-19

Updated: 2018-10-18