Johnson _ Assignment5
docx
keyboard_arrow_up
School
American Military University *
*We aren’t endorsed by this school
Course
290
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
4
Uploaded by marineson21
Week 5 Assignment
Timothy Johnson
ISSC290: Securing Databases
8 July 2023
Week 5 Assignment
Oracle's default password policy serves as a basis for ensuring the security of user
accounts in the database. Nevertheless, organizations may need to adjust this policy to fit their
specific security needs. It is generally advised to assign only those schemas a profile with
password aging and expiration features if users can change their password themselves through
their end-user application when the password expires (The Geek Diary). To create an efficient
and sturdy security framework, modifying the default password policy requires following several
crucial steps.
To begin, you need to connect to the Oracle database using administrative privileges. You
can do this by logging in as a user with the required privileges, such as the system account. After
that, execute the ALTER PROFILE command to change the password policy. The ALTER
PROFILE statement lets you modify different parameters, like password complexity, expiration,
and reuse rules.
If you need to adjust the complexity of password requirements, you can establish certain
criteria like the length of the password, the use of upper and lowercase letters, numbers, and
special characters. It's also wise to make sure that passwords are intricate enough to prevent
unauthorized access by those who try to guess passwords (Oracle). In addition, you can create
rules for password expiration to ensure that users change their passwords on a regular basis. This
helps to improve security and minimize the risk of compromised credentials.
Once the required adjustments have been made, it is crucial to apply them to the relevant
user profiles. This can be accomplished by utilizing the ALTER USER statement, which links
each user to the revised password policy.
To summarize, adjusting the default password policy in Oracle requires establishing a
connection to the database, executing the ALTER PROFILE command to modify settings such as
complexity, expiration, and reuse regulations, and implementing the changes to user profiles. By
personalizing the password policy, entities can bolster the security of their Oracle databases and
safeguard confidential data from unauthorized entry.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
References
The Geek Diary. (n.d.). The Geek Diary. https://www.thegeekdiary.com/beginners-guide-to-
oracle-password-management-policy/
Oracle. (n.d.). The advantages of parallel databases. Techwalla.
https://www.techwalla.com/articles/the-advantages-of-parallel-databases