Skip links

Identifying Predefined Administrative Accounts in Autonomous Database or any other Oracle database

identify oracle predefined accounts

A quick post as a reminder for myself some time down the road.  After all, we all need reminders every once in a while!

Prior to Oracle Database 12c finding a list of default users within the database was always a pain.  In Oracle Database 12c or later, this has become much simpler.  Oracle introduced a column on the *_users views that allows the end users to identify what users are maintained by Oracle.  This column name is ORACLE_MAINTAINED.  The value of the column is either “N” or “Y”.  If it is “Y”, then user account is maintained by Oracle.

A simple query of the ALL_USERS view will return about 57 different accounts that are maintained by Oracle in Oracle Database 19c (Autonomous Data Warehouse).

select * from all_users
where oracle_maintained = 'Y'
order by username;

predefined accounts

For more information, the Oracle Database 19c docs can be referenced here.

Leave a comment

  1. Hello! Do you know if they make any plugins to
    help with Search Engine Optimization? I’m trying to get my site to rank for some targeted keywords but I’m not seeing very good results.
    If you know of any please share. Cheers! You can read similar blog here: Bij nl

  2. You are so interesting! I do not believe I have read something like this before. So good to find somebody with a few unique thoughts on this subject. Really.. thank you for starting this up. This website is something that’s needed on the web, someone with a bit of originality.

  3. Great info. Lucky me I came across your website by accident (stumbleupon). I’ve saved as a favorite for later!

  4. A motivating discussion is definitely worth comment. I think that you need to publish more on this topic, it may not be a taboo matter but typically folks don’t speak about such issues. To the next! Cheers!

  5. You should take part in a contest for one of the greatest blogs online. I am going to highly recommend this blog!

  6. Good information. Lucky me I recently found your blog by chance (stumbleupon). I have bookmarked it for later!

  7. When I initially commented I seem to have clicked the -Notify me when new comments are added- checkbox and from now on whenever a comment is added I get four emails with the same comment. Perhaps there is an easy method you can remove me from that service? Appreciate it.

  8. An interesting discussion is worth comment. I do think that you should publish more about this subject matter, it may not be a taboo matter but generally people don’t discuss these subjects. To the next! Many thanks.

  9. Based on my research, after a property foreclosure home is bought at an auction, it is common for any borrower to be able to still have any remaining balance on the mortgage loan. There are many lenders who try to have all costs and liens cleared by the following buyer. On the other hand, depending on particular programs, laws, and state guidelines there may be several loans which are not easily resolved through the shift of lending options. Therefore, the duty still rests on the lender that has received his or her property in foreclosure. Many thanks sharing your notions on this site.