topic Re: SE_TOOLKIT does not set raster layer permissions in SDE, even though it says it d in Data Management Questions

SE_TOOLKIT does not set raster layer permissions in SDE, even though it says it does

PaulBryson — Fri, 20 Jan 2012 12:16:47 GMT

When I try set the SDE layer permissions on a raster using sderastool, it says it is done, but it does not actually do it.

I have tried it on the following systems (and both don�??t work):
System 1
=======
Windows7
ArcSDE 10.1 SP3 for PostGres
SE_TOOLKIT setk93b41_WIN64_100sp3 (Also tried setk93b41_WIN64_931sp2)

System 2
=======
Win 2003
ArcSDE 10.1 SP3 for SqlServer
SE_TOOLKIT setk93b41_WIN64_100sp3 (Also tried setk93b41_WIN64_931sp2)

Here is the command I run and the result I get:
===============================================

C:/Data/AppsRunDir/RBA/scripts/sderastool.exe" -o revoke -l ldr.RSA_DEM20M,raster -U paul -A SELECT,INSERT,UPDATE,DELETE -i port:5151 -s localhost -D gisdb -u ldr -p ***

ArcSDE 10.0 Raster Management Tool Fri Jan 20 16:05:18 2012
------------------------------------------------------------------------

Access to rasterstore 'ldr.RSA_DEM20M' has been changed

Is there something wrong with my command?
Can anyone help with this please?
Thanks
Paul

Re: SE_TOOLKIT does not set raster layer permissions in SDE, even though it says it d

VinceAngelo — Fri, 20 Jan 2012 12:57:56 GMT

Table permissions should be set via 'sdetable -o {grant|revoke}'. This didn't work correctly
back at 8.01 when 'sderastool -o {grant|revoke}' was created, but it has functioned since
at least ArcSDE 8.2.

It's possible that the API no longer supports grants through the raster functions; if it doesn't,
then I'll disable the option (I'll deprecate it either way).

- V

Re: SE_TOOLKIT does not set raster layer permissions in SDE, even though it says it d

PaulBryson — Fri, 20 Jan 2012 15:08:58 GMT

Thanks that works!, the sdetable command sets the raster permissions correctly.
Thanks for your quick response!