There isn't a way to just create user bobtmp with the settings for bob?

For example.

Create user bobtmp identified by password like user bob;

I know this doesn't work... but is there some syntax similar to this without exp and imp objects?