HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

What's the default password for SYSTEM in Amazon Oracle RDS?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
thewhatsystempassworddefaultamazonforrdsoracle

Problem

I can only remember setting these parameters and definitely not the password for SYSTEM:

  • DB Instance Identifier = mydbinstanceidentifier



  • Master Username = mymasterusername



  • Master Password = mymasterpassword

Solution

The SYS user, SYSTEM user, and other administrative accounts are locked and cannot be used
More

The Amazon documentation for Oracle on Amazon RDS says you have to use master user which has the DBA privilege and other users like SYS and SYSTEM are locked by default and cannot be used.

SYSDBA privilege is not available for customer in Amazon RDS so Amazon EC2 might be a better choice for you and can have full control over the database and high privileged user like SYS and SYSTEM user.

Useful links:

  • Best Practices for Running Oracle Database on Amazon Web Services



  • Common DBA Tasks for Oracle DB Instances



  • Oracle on Amazon RDS

Context

StackExchange Database Administrators Q#151439, answer score: 5

Revisions (0)

No revisions yet.