0

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 1

4

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.

2
  • 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/…
    – Ryan
    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. Apr 26, 2021 at 10:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.