Maintaining public finance role security access in the single database structure

Prior to the implementation of the single database structure, system administrators maintained security access by granting users public access to finance databases.

System administrators working with the single database structure can maintain security access using database roles. There are three public database roles:

• public is not used as it is a standard role that exists in SQL Server
• publicfinance is used to grant general access to the old SynergyOneFinance database
• public{ExtraFinanceDBName} is used to grant access to any additional finance databases created by your organisation. 

Note: {ExtraFinanceDBName} in the description above represents the name of the extra finance database used at your organisation.

Note: Users with existing access to SynergyOneFinance or any additional finance databases are granted security access to the required database roles during migration to the single database structure.

Adding users to database roles

1. To add a user to a database role:
2. Run SQL Server Management Studio from the desktop or Start > Programs > Microsoft SQL Server.
   
   The Connect to Server window is displayed.
   
3. Enter the login details for the server running SQL Server.
4. Click .
   The Microsoft SQL Server Management Studio window is displayed.
   
5. Select View > Object Explorer, if Object Explorer is not already displayed.
   
   The Object Explorer pane is displayed on the left-hand side of the window.
   
6. Drill into the following by clicking the plus sign next to:
   
   • [+] Microsoft SQL Servers
   • [+] SQL Server Group
   • [+] (Your Server Name)
   • [+] Security
   • [+] Database roles.
   
   
7. Right-click the database role you want to add the user to. You can click:
   
   • publicfinance
   • public{ExtraFinanceDBName}.
   
   
8. Select Properties.
   
   The Database Role Properties window is displayed.
   
9. Click Add....
   The Select Database User or Role window is displayed.
   
10. Type the name of the user into the Enter the object names to select field.
11. Click Check Names.
12. Click .
13. Repeat steps 3 through 11 to add additional users to database roles.
14. Save the changes.