Explore BrainMass

Oracle9i Database

1. You have three new consultants arriving to work for your company as database programmers. You want them to be able to create tables in the USER_AUTO tablespace that use up to a maximum of 10 M of space each. In addition, you want them to change their passwords every week, and you want the system to log them off the database if their sessions are idle for more than ten minutes. The three user names to create are CONS01, CONS02, and CONS03. The profile to create for the consultants is named TEMPCONSULT. Write and execute the commands needed to accomplish these goals. Save the SQL script in a file.