create user like %%%%
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: create user like %%%%

  1. #1

    Angry 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

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    I would say just create the user with the normal command, and then export bob's objects and import into bobtmp.

  3. #3
    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

  4. #4
    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

  5. #5
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    I don't think you can do it without Exp/Imp.
    I guess that is what DBA Studio is using behind the scene.

    - Rajeev

  6. #6
    Join Date
    Sep 2000
    Posts
    384
    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
  •  



Click Here to Expand Forum to Full Width