Your company has hired several new people for a new


#User profiles
Your company has hired several new people for a new department project in your regions. This department will have some different requirements from regular works, and the DBA wants to ensure that the new hires will not be getting stepped on by current users in the database and vise versa. To help insulate the new hires, it has been decided to create a specific profile for them. The profile name will be NEWREG1 and it will need to have the following properties:

* After three login attempts, the account should be locked.
* The password should expire after 30 days.
* The same password should not be reused again for at 31 days.
* The account should have a grace period of five days to change an expired password.
* Each user can have 3 concurrent sessions open. 

Could you write the SQL commands that would implement this profile. Next, write the query that would list the profile, the profile resource name, and the limit value for the new profile.

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Your company has hired several new people for a new
Reference No:- TGS0145728

Expected delivery within 24 Hours