Some common database administration tasks cannot be executed in Amazon RDS by using standard commands. Here are some examples:

  • Bringing a database online.
  • Dropping a DB in a mirrored instance.
  • Killing an active session or query.
  • Switching online log files.

How do I perform common DBA tasks for RDS DB instances running various database engines?

In order to deliver a managed service experience, Amazon RDS does not provide shell access to DB instances, and it restricts access to certain system procedures and tables that require advanced privileges.

If you receive a permission or privilege error message when executing a common DBA command or modifying a database variable setting, see one of the following topics for information on how to accomplish the task with Amazon RDS:
Oracle Appendix: Common DBA Tasks for Oracle
MySQL Appendix: Common DBA Tasks for MySQL
MariaDB Common DBA Tasks for MariaDB
SQL Server Appendix: Common DBA Tasks for SQL Server
PostgreSQL Appendix: Common DBA Tasks for PostgreSQL

RDS, shell access, limited, standard commands, DBA tasks, managed service, stored procedure access, table access, restricted, master user

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