topic Re: sdelayer alter in Data Management Questions

sdelayer alter

jayasudha — Mon, 03 Aug 2015 06:49:34 GMT

I have created a feature class under a feature dataset.

Then modified feature class properties by using sdelayer by using feature class owner (same used in creating feature class) and password.

But when i use sde admin credentials, i get error "Layer not found"

Please suggest me....

Re: sdelayer alter

AsrujitSengupta — Mon, 03 Aug 2015 08:42:38 GMT

did you try with the fully qualified name?

Example: data_owner.object_name

Re: sdelayer alter

jayasudha — Mon, 03 Aug 2015 09:29:34 GMT

yes, i have tried with fully qualified name....owner.object

ArcSDE 10.1 for Oracle11g Build 679 Thu Apr 5 11:43:21 2012

Layer Administration Utility

-----------------------------------------------------

Error: Layer not found (-20).

Error: Cannot Modify the Layer

Re: sdelayer alter

AsrujitSengupta — Mon, 03 Aug 2015 13:07:23 GMT

Can you post the command that you used...

Re: sdelayer alter

SamuelTompsett — Mon, 03 Aug 2015 13:07:36 GMT

Hi Jaya,

Can you post the full syntax you are using for sdelayer -o alter?

There may be a different way, using ArcCatalog, to get the same results.

-Sam

Re: sdelayer alter

VinceAngelo — Tue, 04 Aug 2015 01:21:30 GMT

All 'sdelayer' administration should always be performed as the owner schema. If the privileges are set correctly, the SDE user should NOT be able to edit layer metadata for other users, so this behavior is actually good news -- Your instance is working according to design.

You should always be extremely careful using command-line tools against layers registered with the geodatabase. There aren't many cases in which the Desktop tool won't be much safer for your geodatabase integrity.

- V

Re: sdelayer alter

jayasudha — Tue, 04 Aug 2015 11:16:37 GMT

Thanks to all for the discussion.

If it is privilege issue, then fine, sdelayer is working fine with data owner.

If i provide privileges (insert, update, delete) to sde, whether sde can alter feature class properties ?

Re: sdelayer alter

VinceAngelo — Tue, 04 Aug 2015 13:39:59 GMT

I've never even considered giving such permissions, much less tried it, so I have no idea, but I would sincerely hope that it doesn't work. In maintenance utilities I've written, I give a specific error message if the non-owner attempts to make such changes.

It is best practice to avoid using the SDE user for anything beyond instance maintenance. The less you use SDE, the less likely that you'll corrupt your geodatabase.

- V