40 lines
1019 B
SQL
40 lines
1019 B
SQL
|
|
|
|
-- Error Message type
|
|
SELECT * FROM partsltd_prod.CORE_Msg_Error_Type;
|
|
|
|
-- User Change Sets
|
|
SELECT * FROM partsltd_prod.PH_User_Change_Set;
|
|
|
|
-- Access Levels
|
|
SELECT * FROM partsltd_prod.PH_Access_Level;
|
|
|
|
-- Permission Groups
|
|
SELECT * FROM partsltd_prod.PH_Permission_Group;
|
|
|
|
-- Permissions
|
|
SELECT * FROM partsltd_prod.PH_Permission;
|
|
|
|
-- Users
|
|
SELECT * FROM partsltd_prod.PH_User;
|
|
SELECT * FROM partsltd_prod.PH_User_Audit;
|
|
|
|
-- Roles
|
|
SELECT * FROM partsltd_prod.PH_Role;
|
|
SELECT * FROM partsltd_prod.PH_Role_Audit;
|
|
|
|
-- Role Permission link
|
|
SELECT * FROM partsltd_prod.PH_Role_Permission_Link;
|
|
SELECT * FROM partsltd_prod.PH_Role_Permission_Link_Audit;
|
|
|
|
-- User Role link
|
|
SELECT * FROM partsltd_prod.PH_User_Role_Link;
|
|
SELECT * FROM partsltd_prod.PH_User_Role_Link_Audit;
|
|
|
|
-- Contact Form Change Sets
|
|
SELECT * FROM partsltd_prod.PH_Contact_Form_Change_Set;
|
|
|
|
-- Contact Forms
|
|
SELECT * FROM partsltd_prod.PH_Contact_Form;
|
|
SELECT * FROM partsltd_prod.PH_Contact_Form_Audit;
|
|
SELECT * FROM partsltd_prod.PH_Contact_Form_Temp; |