grantaccess, revokeaccess

Description

Grants/Revokes specified privileges to the specified user. Current DBMS user must have sufficient DBMS privileges for grant to work.

Attributes

Attribute Description Required
privilegesComma-separated list of privileges to grant/revoke (possible values: select,insert,update,delete) Yes
userDBMS user name to whom privileges need to be granted/revoked. Yes
adminOnly for "grantaccess": true or false - granted user can/can't GRANT/REVOKE privilege. No. Defaults to false

Examples

  <sde:sdeconnection id="sde.conn" 
      host="127.0.0.1" password="pass" username="myuser"/>
      
  <sde:grantaccess connection="sde.conn" 
      privileges="select,insert"
      admin="false"
      user="scott">
      <sde:tablelist refid="tablelist"/>
  </sde:grantaccess>
  
  <sde:revokeaccess connection="sde.conn" 
      privileges="select,insert"
      user="scott">
      <sde:tablelist refid="tablelist"/>
  </sde:revokeaccess>