What is the proper syntax for creating a user like another user? same tables and whatnot... cloning a user

is it create user bobtmp like user bob?

urgent