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

90
2
02-19-2018 02:10 AM
Highlighted
New Contributor II

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.

Reply
0 Kudos
2 Replies
Highlighted
MVP Regular Contributor

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
Highlighted
Occasional Contributor II

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.

Reply
0 Kudos