- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
DBMS_XMLSCHEMA does not look like owned by sys but XDB. XDB should able to give grant to respective owner.
XDB has no active login and connecting to XDB via proxy (alter user xdb grant connect through <<master user>>) is not allowed.
But... the problem is no longer an issue really: EXECUTE privilege on XDB.DBMS_XMLSCHEMA was granted to PUBLIC; a detail I overlooked. The query I had to check that showed I had an issue, did not check on privileges granted to PUBLIC. So the application can call this package successfully.
Case closed, thank you for your responses!
Contenus pertinents
- demandé il y a un an
- demandé il y a 6 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 4 ans