From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Walkthrough: Create a sales summary schema owner user

Walkthrough: Create a sales summary schema owner user - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Walkthrough: Create a sales summary schema owner user

“

- [Instructor] So, as you can see on my screen here, I've got a list command I did with the exclamation point, which is an oslevel command from the SQL*Plus session. And I wanted to look at my scripts that have the ss, the words or the naming convention of ss in it. You can see these four scripts came up. This would be quite normal if you're going to perform a release. You would be given these scripts and they would be executed in your test, your production databases. And the reason that I'm going to do this is we're talking about now how to manage and work with data inside that database. You need a schema owner that's going to own that. You need to have users that can actually perform those tasks. Many times it's not going to be you as a DB that's doing it. Of course, we're going to be doing it as we actually work through this capstone, but you're going to see how these scripts work. So, the step for this is that we've been told that we need to create a schema owner using the user's…

Contents