Skip to Main Content
DBA Essentials - Administer user accounts and security for Oracle Database 23ai

About This Workshop

Youtube Video

About This Workshop
This workshop aims at explaining user administration and security management for your Oracle Database 23ai so you can access your database with appropriate rights.
You will learn how to view existing roles in the database, create and modify roles, and manage system privileges. You will also manage the user accounts in your database, such as view existing users, create new users, and grant roles to users. You will learn how to unlock user accounts and allow them to log into the database. Additionally, this workshop will guide you to log into your Oracle Database a new user. You will perform all these tasks on your Oracle Database in a web browser using Oracle Enterprise Manager.

Workshop Info

1 hour, 30 minutes
  • Manage database users and roles from Oracle Enterprise Manager
  • View existing roles in the database
  • Create and modify roles
  • View existing database user accounts
  • Create and modify users
  • Unlock user accounts
  • Log into database as a new user
  • Familiar with shell terminals and commands (bash, c shell, etc.)
  • Comfortable with web browsers
  • Familiar with Oracle Database and Oracle Enterprise Manager is desirable, but not required
  • Some understanding of database terms is helpful

Other Workshops you might like