Changing the ownership of a Feature Class and schema.

TobyTe_Rupe1 — Fri, 06 Oct 2017 02:39:17 GMT

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.

Re: Changing the ownership of a Feature Class and schema.

JakeSkinner — Fri, 06 Oct 2017 13:10:47 GMT

Hi Toby,

Try the following:

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

topic Re: Changing the ownership of a Feature Class and schema. in ArcGIS Enterprise Questions

Changing the ownership of a Feature Class and schema.

Re: Changing the ownership of a Feature Class and schema.