Writing sql commands by using SQL Plus

Create a new user in your instance called Jeff identified by a password and assign the default profile to this user.

Assign the default tablespace users and temporary tablespace temp to the user.

Grant the necessary privilege to enable user to connect to the database.

Now create a new profile jeff_prof and set certain limitations to this profile, namely:

Limit the number of times that a wrong password can be entered to 2 before the account is locked.

If the password exceeds the above limit, lock it for 2 days.

Now assign the new profile to Jeff.

Test the profile.

Create a role Admin with the following privileges:-

select, insert, update, delete on the tables location, student, faculty and term

Grant the role Admin to Jeff.

Verify that Jeff has acquired the necessary privilege.