Ticket #423 (closed task: fixed)

Opened 2 years ago

Last modified 1 year ago

how to modify accounts in mulgara

Reported by: russ Assigned to: russ
Priority: high Milestone:
Component: topaz-mulgara Version: 0.6
Keywords: Cc:
Blocking: Blocked By:

Description (Last modified by russ)

howdy.

we need to delete a user (or at least remove admin privileges from them) who is no longer with plos.

i don't *thnk* there's any way to do this through admin or old admin pages.

can you let us know how to:

  • delete a user account from mulgara (i can do the cas/psql side easily enough)
  • remove admin privs from a user in mulgara
  • change a username in mulgara

i'm guessing there's a fairly simple itql way to do this...

when we had to update email addresses for the 0.6 upgrade, we used a script like so: 

set autocommit off; 

delete <info:doi/10.1371/profile/616> <http://xmlns.com/foaf/0.1/mbox> <mailto:hughespllc@webbox.com> from <local:///topazproject#profiles>;

insert <info:doi/10.1371/profile/616> <http://xmlns.com/foaf/0.1/mbox> <mailto:clhughes@rti.org> into <local:///topazproject#profiles>; 

set autocommit on;

can we use something like this? is there any documentation for the structure of the mulgara database yet?

Dependency Graph

Change History

06/25/07 11:38:56 changed by pradeep

There is an account state for all accounts. Disabling an account (ie. setting topaz:accountState to '1') will prevent all access for that user. This state was added precisely to handle situations like this. This would also effectively suspend all admin previleges.

06/25/07 12:01:18 changed by russ

ooh, also, how can we query mulgara for a list of admin users?

is there a schema, even for just the account object, that we can look at to assist in making these queries?

06/25/07 12:01:38 changed by russ

  • description changed.

06/25/07 12:38:16 changed by pradeep

See permit-admin.xml xacml rule for the query it uses. Basically accounts have a set of 'topaz:hasRoles' Roles. And any Role with the 'topaz:role' value of 'admin' is considered an admin user.

The content model used by the PlosOneApp? is all in plosone/libs/otm-models. See UserAccount? and UserRole? objects. These are OTM annotated objects. So look for the @Predicate(uri=) for the predicate URI. Also watch for a @UriPrefix? annotation. (See the Otm wiki page for more details)

(follow-up: ↓ 7 ) 06/25/07 14:29:18 changed by russ

  • owner changed from pradeep to russ.

06/25/07 14:29:30 changed by russ

  • status changed from new to assigned.

i think that's enough for me to work with. thank you!!!

(in reply to: ↑ 5 ) 07/05/07 12:24:47 changed by russ

Replying to russ: given my understanding of otm and the models (limited) the files you reference don't really suffice. i need a real schema. i'll make a separate ticket.

08/07/07 16:25:51 changed by

  • milestone deleted.

Milestone Bugs deleted

08/08/07 17:40:25 changed by amit

  • component changed from topaz to mulgara.

08/28/07 14:09:58 changed by russ

  • status changed from assigned to closed.
  • resolution set to fixed.