#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.
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.
Need a quick solution to this question? Comment on this post!!!
Get Assignment help from the expert. SQL Homework Help ,just question answer is one of the best online homework market place, where you can tutor for any subject
ReplyDelete