Changing the ownership of a Feature Class and schema.

1403
1
Jump to solution
10-05-2017 07:39 PM
TobyTe_Rupe1
New Contributor

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.

0 Kudos
1 Solution

Accepted Solutions
JakeSkinner
Esri Esteemed Contributor

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.
  5. Delete Toby's data

View solution in original post

1 Reply
JakeSkinner
Esri Esteemed Contributor

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.
  5. Delete Toby's data