How to grant SYSDBA access to users on Oracle Cloud v19c

All we need is an easy explanation of the problem, so here it is.

It seems that you can’t grant SYSDBA access to users on oracle cloud. I am using v19c, when trying to alter roles through the web "Database Actions" interface, the only roles I see are; CDB_DBA DBA LBAC_DBA PDB_DBA. How can I make a user SYSDBA?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

In short, you can’t. You need to use PDBADMIN user or PDB_DBA role for such things: https://docs.oracle.com/en-us/iaas/exadata/doc/eccmanagingdatabases.html

Also there is a very useful document:
Known Issues for Oracle Database Exadata Express Cloud Service
It gives some more internal info about cloud access and privileges.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply