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?
1 Answer
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.
-
Thanks for your answer. I added the PDB_DBA role for the ADMIN user. There is actually no PDBADMIN user. What I am trying to do is install utPLSQL on oracle cloud. This is turning out to be more difficult then I envisaged. There is a stackoverflow question relating to this, if you have any insight it woulld be appreciated. stackoverflow.com/questions/66694500/…– RyanCommented Apr 25, 2021 at 11:41
-
Actually that all depends on the kind of database you are using in the Oracle Cloud. For anything autonomous (ADB/ATP/ADW), you just cannot have DBA access: that is the whole point of having your database managed for you. The highest privileged account is ADMIN that lets you do essential maintenance. Commented Apr 26, 2021 at 10:27