topic Re: How to add feature class to another schema(oracle) as different user to connect in Geodatabase Questions

How to add feature class to another schema(oracle) as different user to connect

KydyrovMeirambek1 — Mon, 19 Feb 2018 10:10:39 GMT

How to add feature class using ArcCatalog 10.3.1 to another schema. ArcCatalog connected to oracle database as user1. I must to add the feature class to schema on user2. User2 not contain connect privilege. I will be very glad to you suggestions.

Re: How to add feature class to another schema(oracle) as different user to connect

Asrujit_SenGupta — Mon, 19 Feb 2018 16:24:50 GMT

To create data under a schema, you have to connect as that User and the user also needs the required permissions for creating data.

Privileges for geodatabases in Oracle—Help | ArcGIS Desktop

Data creator
CREATE SEQUENCE
CREATE SESSION
CREATE TABLE
CREATE TRIGGER
CREATE VIEW

Re: How to add feature class to another schema(oracle) as different user to connect

TinaMorgan1 — Sat, 24 Feb 2018 00:06:02 GMT

User2 must have permissions to not only connect, but to also create data.

Apply permissions to User2, then make a database connection as user2 in ArcCatalog. Copy and paste the data into User2's connection. The end results will be duplicated data in the schemas user1 and user2. From there you can delete the data in user1 schema.