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…
Author
David Yahalom
Released
11/9/2016After 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
Duration
Views
-
Introduction
-
Welcome1m 34s
-
Target audience1m 13s
-
Exercise files19s
-
-
1. Architecture
-
Database instance3m 26s
-
Database storage4m 14s
-
Server processes5m 56s
-
-
2. Instance Memory Pools
-
System global area2m 19s
-
Shared pool5m 37s
-
Buffer cache3m 37s
-
Redo log buffer4m 46s
-
Other SGA pools and the PGA3m 51s
-
SGA and PGA sizing4m 24s
-
-
3. Instance Background Processes
-
Database writer4m 58s
-
Log writer6m 2s
-
Checkpoint process2m 30s
-
SMON process44s
-
PMON process38s
-
RECO process1m 35s
-
LREG process2m 27s
-
Archiver process2m 15s
-
-
4. Client Connections
-
Oralce listener5m 22s
-
TNSNAMES.ORA config files5m 30s
-
How client connections work2m 55s
-
-
5. Physical Database Structures
-
Database storage file types2m 26s
-
Datafiles and tablespaces8m 39s
-
Redo log files4m 5s
-
Control files2m 4s
-
Backup files4m 49s
-
Additional storage files3m 19s
-
-
6. Mulitenant Database
-
New vs. Old2m 22s
-
Backward compatabiltiy1m 19s
-
7. Start and Stop the Database
-
8. Install Oracle 12c software
-
Prerequisites for installation14m 10s
-
O/S configuration6m 43s
-
Download the software4m 3s
-
Install software6m 36s
-
-
9. Create a Database Instance
-
Use DBCA to create a database14m 55s
-
10. Tools for Developers and DBAs
-
SQL *Plus for administration4m 16s
-
SQL Developer for development13m 57s
-
Oracle Enterprise Manager8m 14s
-
-
11. Management
-
Start and stop the instance3m 20s
-
View and set parameters5m 27s
-
Data dictionary8m 20s
-
-
Conclusion
-
Next steps1m 17s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Create users and assign permissions