SQL User Manager

User Managers provide user information required to work with K2[blackpearl]. The default user manager is Active Directory. K2 plugs straight in to your AD environment out of the box. So that you can use your AD objects to manage security, assign tasks, find out the email address of the manager’s manager of a user and so on. K2[blackpearl] also comes with a SQL database based user manager called SQLUM.

SQL User Manager uses a set of database tables to gather the user information required. All this info resides in the database called K2SQLUM which gets installed when you first configure K2[blackpearl]. There are 14 databases that gets installed on your choice of Sql2005 instances. SQLUM is the only DB that you are allowed to modify.

If you look at the table structure of this DB it is straight forward. You have tables for Users, Groups and memberships. (Note Roles are stored in the HostServer database) You can populate these tables with relevant info and you are away. You can also setup views on this DB that pull user data from other systems.

Great thing about K2’s use of SQLServer is that all your microsoft database techniques can be employed. All your clustering, backup, security and management is standardised.

1 Comment

  1. [...] General | By default K2 uses AD for its authentication and authorisation mechanism. It also ships with a Security provider which allows you to use a database as an alternative to user information [...]

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,102 other followers

%d bloggers like this: