RDS permission issue

0

Error-Screenshot Hello AWS, I have a Client requirement to create a USER and Grant ALL PRIVILEGES to this newly created USER. These SQL Queries are working on my on-premises Oracle Database but when executing the same in AWS's Oracle RDS instance, the Query is not working for my newly created user it shows the privileges error! I'm unable to give ALL PRIVILEDGES for newly created USER in RDS. Have pasted and attached the following queries and the Error faced.

alter session set "_ORACLE_SCRIPT"=true; create user mendix_so_8_10 identified by 1; GRANT ALL PRIVILEGES TO mendix_so_8_10;

Kindly Requesting your team to give us a working solution to our problem. Awaiting your reply at the earliest. Thanks & Regards, Madhumitha. B

1 Answer
0

When you have Database instance in AWS i.e. RDS, you will never be granted the FULL blown Admin as this could be used to elevate access to the underlying operating system.

Please see the table in the link of the Maximum privilege that your master user will be grated. You may NOT grant any access higher than what the master user is granted. You can see in your error message that you cant alter SYSTEM access.. This is because AWS does not allow SYSTEM to be altered.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.html

If this answers your question, please be sure to accept so that this helps others and me.

profile picture
EXPERT
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions