Re: Can roles be copied?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 16 Feb 2005 08:01:01 -0800
Message-ID: <1108566295.925610.200140@g14g2000cwa.googlegroups.com>

Do you want all users or just certain users? If all users then you can use a full exp with rows=n to extract all DDL, grants, users, roles, etc... and then import that.

You can use a user export for just one user's objects but this will not get roles.

The create script for a role is fairly easy to generate from the dictionary views or you can cut it out of a full exp dump with a little editing code.

HTH -- Mark D Powell -- Received on Wed Feb 16 2005 - 10:01:01 CST