sdelayer alter

[jayasudha]

hi

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....

[AsrujitSengupta]

did you try with the fully qualified name?

Example: data_owner.object_name

[jayasudha]

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

[AsrujitSengupta]

Can you post the command that you used...

[SamuelTompsett]

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

[VinceAngelo · Accepted solution]

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

[jayasudha]

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 ?

[VinceAngelo]

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