Skip to content
February 4, 2013 / doganay

USERS THAT HAVE DEFAULT PASSWORDS

select username from DBA_USERS_WITH_DEFPWD order by 1;

Change scott’s pwd:
SQL> alter user scott identified by “Newpassword123”;

select username from DBA_USERS_WITH_DEFPWD order by 1;

You do not see scott in that list.

Change scott’s pwd back to default:

SQL> alter user scott identified by "tiger";

Again, scott apeears in the list:

select username from DBA_USERS_WITH_DEFPWD order by 1;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: