Case 3-1 Training Case You were hired as a database security expert to train the

Question

Case 3-1 Training Case

You were hired as a database security expert to train the database administration team.At the first training session,you ask the trainees to perform the following tasks using Oracle Enterprise Manager or SQL*Plus. Describe what you expect your trainees to produce.

Create a user named CH0306 with the password CH0306.

Modify the user options using SQL*Plus to change the default tablespace and temporary tablespace to TOOLS and TEMP respectively.

Lock the account.

Using SQL*Plus change the user password to DBSEC. (Optional)

View the account using the data dictionary.(You can provide a screenshot)

View user quotas using the data dictionary.

At the second training session,you ask the students to outline a list of the best three practices of user administration.List what you expect your students to produce

Explanation / Answer

We expect minimum basic syntax..like creating user account and DDL commands like select delete alter create commands.

--------------------------------------------------
CREATE USER 'CH0306'@'localhost' IDENTIFIED BY 'CH0306';
GRANT ALL PRIVILEGES ON * . * TO 'CH0306'@'localhost';
FLUSH PRIVILEGES;

modifying tablespace
----------------------------
CONN localhost@CH0306
ALTER DATABASE DEFAULT TABLESPACE users;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp;
----------------------------------------
locking account
------Access denied for user 'CH0306'@'localhost'

-------------------------------------------------------------------
set password:
SET PASSWORD FOR 'CH0306'@'localhost' = PASSWORD('DBSEC');

-------------------------------------------------------
SELECT `COLUMN_NAME`
FROM `YOUR_SCHEMA`.`COLUMNS`
WHERE `TABLE_SCHEMA`='yourdatabasename'
AND `TABLE_NAME`='yourtablename';

------------------------------------------------------------------------------------------
connect = host=localhost dbname=CH0306 user=CH0306 password=DBSEC
map {
pattern = priv/quota/storage
table = used_quota_table
username_field = userdbname
value_field = bytes
}
map {
pattern = priv/quota/messages
table = used_quota_table
username_field = userdbname
value_field = messages
}

----------------------------------------------------------------------------

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.