QA

Verify that the default permission and level associations are correct.

System Administrator

Unknown

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

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