-
IMPORT USER HELP
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
Chester Ney
CODY Computer Services
System DBA
-
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?
Chester Ney
CODY Computer Services
System DBA
-
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.
Chester Ney
CODY Computer Services
System DBA
-
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
/
Radhakrishnan.M
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|