Select to view content in your preferred language

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

734
2
01-20-2012 04:16 AM
PaulBryson
Deactivated User
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
0 Kudos
2 Replies
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos
PaulBryson
Deactivated User
Thanks that works!, the sdetable command sets the raster permissions correctly.
Thanks for your quick response!
0 Kudos