Topic Last Modified: 2012-06-25
tblRoleType is a static lookup table with role types and their
associated permission sets.
Columns
Column |
Type |
Description |
rtypeID
|
int, not null
|
Role type ID.
|
rtypeDesc
|
nvarchar (256), not null
|
Role type description. There are four available roles:
-
Member: Chat room member
-
Manager: Chat room manager
-
Voiced: Presenter for an auditorium chat room
-
Creator: Can create chat rooms
|
rtypeAllowedPermSet
|
bigint, not null
|
Permission set for the role. The used bits are:
-
2: True if the role can manage nodes.
-
4: True if the role can create children nodes.
-
7: True if the role can join a chat room (or children chat rooms
of a category).
-
8: True if the role can chat in a chat room (or in children chat
rooms of a category).
-
10: True if the role can read chat history even when not joined
to a chat room.
-
11: True if the role can see the chat room. (This is further
refined by factors such as scope and visibility.)
-
12: True if the role can chat in an auditorium chat room.
-
13: True if the role can bypass visibility rules when viewing
nodes.
|
Key
Column |
Description |
rtypeID
|
Primary key.
|