Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
themeEclipse
languagetext
CREATE TABLE `users``roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL, `org_id` int(10) unsigned NOT NULL DEFAULT '1',
 `password` varchar(250) NOT NULL, `full_name` varchar(100)`description` text NOT NULL,
 `email` varchar(100) NOT NULL, `roles` `permissions` text NOT NULL,
 `orgs` text NOT NULL, `lang` enum('de','en','es','fr','pt-br') NOT NULL DEFAULT 'en', `active` `ad_group` varchar(1100) NOT NULL DEFAULT 'y', `ldap` text NOT NULL,
  `edited_by` varchar(200) NOT NULL DEFAULT '',
  `edited_date` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  PRIMARY KEY (`id`), KEY `user_id_index` (`id`) 
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;

A typical entry looks as below.

Code Block
themeEclipse
languagetext
         id: 1
       name: admin
     org_id: 1
   password: 0ab0a153e0bb0d80c50a02d08c07f0c87080eb0502f5057d30e308d204408c8068e9f4075c0eb61056107b050dd30090650b20b02109230b210be540903ca0b6
 0ab0a153e5bbcd80c50a02da8c97f3c87686eb8512f5457d30e328d2d4448c8968e9f4875c2eb61356197b851dd33f90658b20b32139233b217be54d903ca3b6 full_name: Administrator
      email: admin@openaudit
      roles: ["admin","org_admin"]
       orgs: [1]
       lang: en
     active: y
       ldap: 
  edited_by: Administrator
edited_date: 20002017-0105-0131 0021:0040:0059

API / Web Access

You can access the /users collection using the normal Open-AudIT JSON based API. Just like any other collection. Please see the API documentation for further details.

...