patternMinor
What's the default password for SYSTEM in Amazon Oracle RDS?
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
Useful links:
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.