This is also another interesting
question. Suppose if you get a dump from the source database and you are not
aware of the users/schemas present in the dump. If you wanted to see the list
of schemas/users present in the dump file, you can use this method to find out
the same.

Step 1. Import the dump withsqlfileoption.

This will create a file with
allsqlscript inside the dump. The parameter
value for thesqlfilewould be the generatedsqlfile.

Step 2:grepfor the “CREATE USER” in the
generatedsqlfile. This will list out the Users/schemas present in the dump.