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.

Assignment: Create a sales summary schema owner user

Assignment: 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

Assignment: Create a sales summary schema owner user

“

- [Instructor] Okay, for this part of the assignment, we're going to create a schema owner. This is the SS user. It stands for sales summary, which is the objects we're going to be creating in the upcoming sections of the assignment. So you're going to start by creating that schema owner, SS, and it's going to have unlimited quota on the table space users. It should have the ability to select on any table, create tables, views, procedures, triggers, synonyms, and dimensions and functions. You're going to need to also create a new reporting user called SSRO. That's for sales summary read only user. You are going to grant privileges so the new user can read from any table. And you also need to check how could you change this user to have rights to create any table in the database for future use. And then grant rights so it can now create any tables as well. The hints and the callouts on this step is going to be remember to fully qualify your names if needed. Remember to be in the…

Contents