Changing the ownership of a Feature Class and schema.

TobyTe_Rupe1

Currently I am using AD groups to Data creators, Editors and Readers.  This is working great.  When a user in our AD creator groups creates a new Feature it will create a new Schema for this user. i.e user toby from AD domain dpi (dpi\toby) create a new feature on Database GISDB, will create table with the prefix dpi\toby.

and the associated schema dpi\toby.The issue I have is when Toby leaves the department we would like ot transfer the dpi\toby schema and associated tables etc to a new owner dpi\Jane.How can I accomplish this?Thanks in advance.

JakeSkinner

Hi Toby,

Try the following:

1. Create the new user/schema you would like to own Toby's data
2. Grant 'SELECT' privileges to the new user for all of Toby's data using ArcCatalog
3. Connect as the new user
4. Copy/paste Toby's data and it will now be dpi\newuser.Delete Toby's data