This video provides an overview of the process of creating database users, assigning permissions to users, deleting users and understand the concept of database roles.
- [Instructor] Oracle comes built-in…with a super user called Sys.…Connecting to Sys from SQL Plus requires either…adding as sysdba to the postfix,…such as sqlplus…sys/ the password,…which is oracle in my case,…and as sysdba.…This will open a connection to the Oracle instance…as the most powerful sys or sysdba user.…
Alternatively, we can just type…sqlplus, quotation marks, as sysdba,…and be connected to the instance…with the sys, sysdba user.…We don't need to supply a password…specifically for the sys user,…only because we are physically logged on…to the same server where the Oracle instance is running.…And, we are running SQL Plus from the Oracle Linux user,…which is the user that started the Oracle instance.…
That is the only reason why we can skip the password…for such a powerful user when logging on to the database.…A connection with sys from any other machine…in our network to our database,…would have required us to supply the password.…Creating additional users in Oracle is also extremely easy.…In order to create users, we'll need to first log on…
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
Learning Relational Databases (2014)with Adam Wilbert2h 39m Beginner
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 55s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.