CORE DBA - USER MANAGEMENT USEFUL COMMANDS

1. checking the newly created user profile type

          SELECT USERNAME , PROFILE FROM DBA_USERS WHERE USERNAME='USER';

                       USERNAME        PROFILE

                       ----------- ------------------- ------------------------------

                          EX        DEFAULT

   2.   checking the encrypted form of password of user

             SELECT NAME,PASSWORD FROM  SYS.USER$ WHERE  NAME='USER';

                        NAME        PASSWORD

                    ------------------------------ ------------------------------

                          EX        DC6300AB63DA29DF