How to assign the correct SQL database permissions?

To assign adequate SQL database permissions within SQL Server Management Studio, follow the below steps:

1. Select User mapping and select the Database Name and assign Database roles as “db_datareader” and “db_datawriter” (public is by default selected and can’t be selected).

2. Similarly, do the same for each database below:

DemoGenericData
Electrical GenericData
HydraulicGenericData
HyDrawData
PneumaticGenericData
SubsystemData

3. Click OK

To create new folders within the symbol library, you will additionally need the sysadmin role to be assigned to the user who will be creating the folders.