Session_4_notes_EF - Slide Notes: Slides 1-18 Password...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Slide Notes: Slides 1-18 Password Management The default password management in Oracle is weak, but it is a good start. To find out what the defaults are you can query them using the SQL example in slide 3 (or look the defaults in Oracle documentation if you have it). You can also create your own password profile or as many password profiles as needed to fit your security policy. You might have different password rule based on roles or some other criteria. You can change the default profile to a recommended set of values that will make the default password profile stronger by running utlpwdmg (see slide 4). If you compare slide 3 to slide 4 you will see what changes were make by utlpwdmg, e.g., the number of failed login attempts was changed from unlimited to 3. Any user you create will be subject to the default password management policy unless you create your own password policy and assign users to it when you create them. To change the profile (or to create one) you use the Create or Alter Profile Statement, slide 6 has an example showing the creation of a special profile called My_Profile. Slide 7 shows an example or creating a user and assigning the user to a special profile
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/23/2009 for the course DBST dbst 668 taught by Professor Yelena - ta during the Spring '09 term at MD University College.

Page1 / 2

Session_4_notes_EF - Slide Notes: Slides 1-18 Password...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online