...
| Code Block |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | 1. Insert new row for state (repeat for each state/province) |
|---|
|
insert into krlc_st_t values ('SS', 'CC', sys_guid(), 1, 'State Name', 'Y');
-- Replace SS with two-digit state/province abbreviation; these are used in S2S submissions so they should match the official designations.
-- Replace CC with the two-digit country abbreviation (found in the Country maintenance table)
-- Replace State Name with the name of the state/province; this is what will display in the drop-down. Be careful about copy-pasting special characters as they may not show up correctly. |
Remove Inactive Departments from User
Request: Person/User record cannot be edited because of inactive departments in their permissions.
| Code Block |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | 1. Run stored procedure on user to clean up permissions for inactive departments |
|---|
|
exec remove_inactive_unit_perms('efitzp01'); -- Replace with user's UTLN |
Grant Admin permissions to a user (full access)
...