question How are users related to groups or roles? in ITOM forum

How are users related to groups or roles?

Geeky — Tue, 26 Aug 2014 19:03:58 GMT

Can anybody answers this?

How are users related to groups or roles?

One to many relationships

Many to many relationships ?

Re: How are users related to groups or roles?

peterwestergaar — Tue, 26 Aug 2014 19:14:48 GMT

Users (table sys_user) are related to Roles (table sys_user_role) with a many-to-many table (sys_user_has_role) which keeps records that each have a reference to one User and one Role. When you add a Role directly to a User, a record is generated in the sys_user_has_role table. When you remove a role from that User, the record is deleted.

Similarly, Groups (table sys_user_group) are related to Users with a many-to-many table (sys_user_grmember), which has records that each reference a single Group and a single User.

Does that help?

Re: How are users related to groups or roles?

Geeky — Tue, 26 Aug 2014 19:20:32 GMT

Thanks for the explanation Peter. Is it only a theoretical concept or can I see it?

Re: How are users related to groups or roles?

Brad Tilton — Tue, 26 Aug 2014 19:26:57 GMT

In the related lists section on users, groups, and roles you can see the related lists, which are actually views of the relationship tables sys_user_grmember and sys_user_has_role. That allows you to actually look at the records on those tables.

Re: How are users related to groups or roles?

peterwestergaar — Tue, 26 Aug 2014 19:27:13 GMT

well, like with most any ServiceNow table, you can examine it by going to the filter at the top of the sidebar and entering the tablename followed by ".list" ... don't press ENTER when you're done.

Just enter: sys_user_has_role.list

... and you'll get the list of all pairings of user and role. Obviously you can only do this as an administrator. Well, you can still perform the search, but most (often ALL) of the records will be invisible to a non-administrator.

Re: How are users related to groups or roles?

dhananjay21 — Fri, 07 Dec 2018 05:18:07 GMT

Hi Brad,

If i want to create a replica relationship of Group on User table with the new and edit buttons how would i achieve it.

Can you help me ? , It would be great if you lead me in an appropriate direction.