create user like %%%%

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

I would say just create the user with the normal command, and then export bob's objects and import into bobtmp.

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?

I am using 8.16 by the way... on an nt 4 server...

I figured out how to do it, but I had to use DBA studio.

I don't think you can do it without Exp/Imp.
I guess that is what DBA Studio is using behind the scene.

- Rajeev

Try this

SELECT username,
account_status,
default_tablespace,
temporary_tablespace,
profile,
granted_role,
admin_option,
default_role
FROM sys.dba_users a, sys.dba_role_privs b
WHERE a.username = b.grantee
ORDER BY username,
account_status,
default_tablespace,
temporary_tablespace,
profile,
granted_role
/