Database Assignment Help: Execute your script to create the new user...

#User roles
You need to create a new user named ASSOCDBA1 and a new ROLE named JRDBA1 that can be used for an assistant DBA. You want the new role to contain the DBA role that the SYSTEM user has with ADMIN OPTION (when it pertains to the current SYSTEM user setting). You also want the new role to be password-protected with a password of MJOAG2T. Once the role is created, assign the role to the new user ASSOCDBA1, but do not make it the default role.

Execute your script to create the new user, the new ROLE, assign privileges to the role, and assignment of the ROLE to the user.

Need a quick solution to this question? Comment on this post!!!

SQL Homework Help: Could you write the SQL commands that would implement this profile...

#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.

Need a quick solution to this question? Comment on this post!!!

Database Queries: Write and execute the SQL commands..

New data types
Q) You are going to create new table to be housed in the USERS01 tablespace.
The table name will be METALS and will be used to store a description of various metals. The following offers some additional direction on how the table should be created.

* The table shall have a primary key called METALS_ID.
* An inline primary key constraint shall be defined. The constraint name shall be METALS_ID_PK shall be used.
* An addition column of METAL_DESCRIPTION shall be added to the table definition.
* A unique constraint on METAL_DESCRIPTION shall be added to the table definition. The constraint name shall be METAL_DESC_UK shall be used.
Can you write and execute the SQL commands.

Need a quick solution to this question? Comment on this post!!!