ST.Script.01.Verify Permission and Level Associations
- Former user (Deleted)
- Former user (Deleted)
Verify Permission and Level Associations
Script Information
Description |
Verify that the default permission and level associations are correct. |
|---|---|
Role(s) |
System Administrator |
Dependencies |
|
Time required |
Unknown |
Testing Steps
Step |
Action |
Expected Result |
|---|---|---|
1 |
Establish a connection with the Staging database. |
The associated tables are displayed. |
2 |
In the query analyzer enter Select Name, Change_Settings, Delete_Any, Delete_Own, Mark_As_Read, Move_Posting, New_Forum, New_Response, New_Response_to_Response, New_Topic, Post_To_Gradebook, X_Read, Revise_Any, Revise_Own, Moderate_Postings from MFR_Permission_level_t |
Your output should resemble the table below |
Name |
Change_Settings |
Delete_Any |
Delete_Own |
Mark_As_Read |
Move_Posting |
New_Forum |
New_Response |
New_Response_to_Response |
New_Topic |
Post_To_Gradebook |
X_Read |
Revise_Any |
Revise_Own |
Moderate_Postings |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Owner |
1 |
1 |
0 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
0 |
1 |
Author |
1 |
0 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
0 |
1 |
0 |
Nonediting Author |
1 |
0 |
0 |
1 |
0 |
1 |
1 |
1 |
1 |
1 |
1 |
0 |
1 |
0 |
Contributor |
0 |
0 |
0 |
1 |
0 |
0 |
1 |
1 |
0 |
0 |
1 |
0 |
0 |
0 |
Reviewer |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
0 |
0 |
0 |
1 |
0 |
0 |
0 |
None |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |