Skip to content

Instantly share code, notes, and snippets.

@kbaesler
Created November 19, 2015 18:21
Show Gist options
  • Save kbaesler/2582cff941a1ab0d500e to your computer and use it in GitHub Desktop.
Save kbaesler/2582cff941a1ab0d500e to your computer and use it in GitHub Desktop.
An ArcGIS SDE script for deleting, creating and granting permissions to a multiversion view.
sdetable -o delete_mv_view -t CustomerInformation -i sde:oracle11g:/;LOCAL=[DATABASE] -u [USERNAME] -p [PASSWORD] -N
sdetable -o create_mv_view -T CUSTOMERINFORMATION_MV -t CUSTOMERINFORMATION -i sde:oracle11g:/;LOCAL=[DATABASE] -u [USERNAME] -p [PASSWORD]
sdetable -o grant -t CUSTOMERINFORMATION_MV -U [ROLE] -A SELECT,INSERT,UPDATE,DELETE -i sde:oracle11g:\;LOCAL=[DATABASE] -u [USERNAME] -p [PASSWORD]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment