SYSBACKUP a user to perform backup and recovery operations either from Oracle Re

Question

SYSBACKUP a user to perform backup and recovery operations either from Oracle Recovery Manager (RMAN) or SQL*Plus.

Find all information about SYSBACKUP and SYSDG accounts and unlock them (code and screenshot)

Worksheet Query Builder 1 SELECT usernane, COUNT () as nn FRON cdb_users 2 GROUP BY useriane ORDER BY nun: script Output x [>Query x Lita Ek SQL Al Rows Fetched: 4in 0.02 seconds USERNAME NUM 33 ANONYMOUS 34 SI_INFORMTIN SCHEMA 5 APEX 040200 36 DIP 37 SYSBACKUP 38 SPATIAL_CSW ADMIN_USR 39 FLONS FILES

Explanation / Answer

Solution:

SELECT username, num
FROM dba_users
ORDER BY created;

USERNAME NUM
---------------------- ------------------
SYS OPEN
SYSTEM OPEN
SYSKM EXPIRED & LOCKED
SYSDG EXPIRED & LOCKED
SYSBACKUP EXPIRED & LOCKED

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.