From the course: Oracle Database 12c: Security

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Deleting a database user

Deleting a database user - Oracle Database Tutorial

From the course: Oracle Database 12c: Security

Start my 1-month free trial

Deleting a database user

“

- [Narrator] Every database user account you create, you can also delete. We use the drop user command to delete an existing Oracle database user. Let's see an example. We'll start by connecting to our plug able database as the sysdba user. So I'm typing SQL plus sys slash Oracle at Orcl as sysdba. And let's create two users which we will soon delete. So create user, new user one, identified by secret, and create user, new user two, identified by secret. So we have both new users created. Let's also grant some basic system privileges to these users. So I'll type grant create session, which remember allows a user to connect to the database, create table, to new user one, new user two. As you can see I can grant multiple privileges to multiple database users using a single command. How cool is that? Now let's verify that both users have been created by querying the DBA underscore users view. You can find the query included in your exercise file. So let's copy this command, and paste it…

Contents