Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Oracle connector locks my account

Hello,   I found that the Oracle connector is locking my Oracle user account. When my password is expired, I check if the report is open in Power BI Desktop (if so, I close it), I change my passwor...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous,

 

One of the reasons of your problem could be the password policy you are using. And if there is no such policy of yours then check your settings for the password properties in the DEFAULT profile with the following query:

 

SELECT resource_name, limit
FROM dba_profiles 
WHERE profile = 'DEFAULT'
AND resource_type = 'PASSWORD';

And If required, you just need to change the PASSWORD_LIFE_TIME to unlimited with the following query:

 

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

 

Also you can check this Link to find more details.

 

Regards,

Frank

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello v-frfei-msft,

 

 

If I understand you well, you want me to change the password policy in order it never expires. If yes, I can't change that in my organization, I need to follow that policy.

 

Thanks

Jonathan