Question: Create a database user account Create 7 users as follows: a ) 2 users using A user authenticated by windows OS . b ) 2

Create a database user account
Create 7 users as follows:
a)2 users using A user authenticated by windows OS.
b)2 users using SQL statement and 2 users using GUI in Enterprise Manager.
o Apply the following parameters to the above 4 users.
The default table space is USERS.
The temporary table space is TEMP.
The user has to change his/her password the first time when he/she log in the database.
The user account will be assigned to the DEFAULT profile.
The USERS table space has a 30MB quota.
At the end of the creation, list the user information that shows a successful creation of the above user account
Modify a user using Enterprise Manager GUI.
Drop a user using Enterprise Manager GUI.
Show me the below details:
1. A screen shot of users information after successful creation (View dba_users).(Show query and result)
2. A screen shot after executing each query. (Show query and result)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!