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: User management

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

“

- [Instructor] We're onto the next assignment, which is user management. Set of questions that are posed to you now are, number one, query what users are in the FREEPDB1 database. Second question, query the name of the users and their default table space. Third question, tell me how many objects are in the SH schema, and how many are for each object type. That's the real goal here. Give me those quantities and set 'em up for each object type. Four, query the username, SID, serial number, as well as the application information for those logged into the database. Five, using the information from the previous query, identify those using either SQL*Plus or SQLcl. And six, what would a kill session command look like? Couple callouts and hints. Verify that you're in the PDB with the sample schemas for this exercise. You will need that. Hint, objects can be more than just tables. Don't just think we're talking about tables here. And also, be careful to join on the views by the right columns.…

Contents