5
Sep

Enforcing password complexity for database users

It is recommended to enforce checks and response actions for failed logins, password complexity, password expiration and password reuse.
 
Password complexity can be implemented through profiles.
 
The script for password management implementation utlpwdmg.sql can be used to create a new function to verify password complexity rules.
 
Verify Function is a quick and easy way to enforce quality of database passwords—for example, they should contain a certain number of characters, should not be identical to the username, and so on.
 
By executing this script utlpwdmg.sql, it will attach the function to the profile DEFAULT, which is the default profile for all users.
 

The following password complexity is set with the 'utlpwdmg.sql' script.
 

  • Password length less than 8
  • Password same as or similar to user
  • Password same as username reversed
  • Password same as or similar to server name
  • Password too simple
  • Password must contain at least one digit, one character
  • Password must contain at least one digit, and one character
  • Password should differ from the old password by at least 3 characters
  • Read more...

    3
    Aug
    3
    Jul

    Forms Service shows down in Oracle Enterprise Manager Cloud Control 12c

    Symptoms

    Forms service shows down for the E-Business Suite instance discovered in OEM but it is Up.

    Cause

    Wrong Forms URL

    Solution

    1. Go to targets-->All targets

    2. In the Search Target Name, enter "Forms" or in the Search LOV select "Forms" then click (Go) button

    Read more...

    14
    Jun

    How to Create a Read Only APPS Schema in Oracle E-Business Suite

    Create an APPS READONLY user

    There are 2 ways to achieve this:

    1) Create a user and grant select option to that user.

    This will have to be done individually for all users that you want to have as read only.

    2) Create a readonly role and assign users this role.

    This will have to be done once and then assign this role to the users.

    Read more...

    1
    May

    New Simplified Home Page in Oracle E-Business Suite 12.2

    One of the most visible (and colorful!) user interface enhancements for Oracle E-Business Suite Release 12.2.4 is the new simplified home page:

    Enabling the Simplified Home Page

     

    When you first install or upgrade to Release 12.2.4, you will see the home page as it appeared in previous versions of Release 12.2 (configurable home page with tree-based navigator).
    Read more...

    Back to Top