NotesSQL Command to remove a user from the ACL

HCL Domino Domino Forum
1

I would like to execute a command from java via the NotesSQL driver to remove a user from the ACL.

Can this be done? If so, what is the command I would execute?

Sample syntax greatly appreciated!

2

Subject: NotesSQL Command to remove a user from the ACL

I’ve never done that, but I’m afraid with NotesSQL you can only manipulate DATA Notes, but no designElements.

Why dont you do that with native Notes functions?

Just look up the Designer Help database, and you’ll find what you need…

The Notes client offers a broad set of java functions…

import lotus.domino.*;

public class JavaAgent extends AgentBase {

public void NotesMain() {

try {

  Session session = getSession();

  AgentContext agentContext = 

     session.getAgentContext();

  // (Your code goes here) 

  Database db = agentContext.getCurrentDatabase();

  ACL acl = db.getACL();

  ACLEntry entry = acl.getFirstEntry();

  do {

    System.out.println(entry.getName()); }

  while ((entry = acl.getNextEntry(entry)) != null);

} catch(Exception e) {

  e.printStackTrace();

}

}

}