Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Autonomous database - DBA rights

edited Sep 24, 2019 5:28AM in OCI - General 1 comment

Content

The user ADMIN in the cloud database has no DBA rights.

Why?

How can I create a DBA account?

--------------------------------

SQL> select sys_context('userenv', 'isdba') from dual;

FALSE

SQL> drop user FLOWS_FILES cascade;

ORA-01031: "insufficient privileges".

 

Version

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!