What will happen when one of the users from the group logs on to the database?

The Administrator has dropped a profile which was associated with a group of users.

What will happen when one of the users from the group logs on to the database?
A . The default profile setting for the user will be reset to NULL.
B . Password attributes defined at the system level in DBCSecurityDefaultsV will apply
C . The system will show a warning message.
D . SPOOL and DEFAULT DATABASE specifications for the dropped profile will still apply to the user.

View Answer

Answer: B

Explanation:

When a profile is dropped, the users who were associated with that profile will no longer have the specific resource and configuration settings defined by that profile. Instead, the system-level default settings, such as those specified in DBC.SecurityDefaultsV, will apply to the users. This includes password attributes and other system-wide settings.

Option A (The default profile setting for the user will be reset to NULL) is not accurate, as the system will revert to the default settings rather than leaving values unset.

Option C (The system will show a warning message) does not typically occur when a profile is dropped. The system will manage the transition without user-facing warnings at login.

Option D (SPOOL and DEFAULT DATABASE specifications for the dropped profile will still apply to the user) is incorrect because once the profile is dropped, its settings no longer apply to the users who were associated with it.

Thus, the correct outcome is that system-level attributes defined in DBC.SecurityDefaultsV will govern the users’ settings moving forward.