XSW: how to configure read only access for users accessing the XSW SQL server database
Currently, ?sysadmin? access is needed to even start the XSW GUI and connect to the SQL DB.
So, the read-only access for a user is not working and is not supported.
If you are unable to locate the solution needed or if you need additional assistance please Click Here to open a case from our Customer Care Portal.
Related Articles
XSW: How to add new XSW users to the XSW SQL server database
To assign a new user to the xsw_role, In SQL server management studio, select: Security logins right-click on the user to be added to the xsw_role properties user mapping then select xsw_role and hit "OK" to save the change. If you are unable to ...
XWG: How to find out the XSW database version in SQL SERVER?
The easiest way is to Open the SQL Server Management Studio and run the below query. In the example below, the database version is XSW 3.25. Open Microsoft SQL Server Management Studio. Click to open Databases folder Right click on the XYGATESW ...
XSW: Enabling SQL Remote Connections
Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer. 1. Open MS/SQL Management Studio and right-click server name in the left pane and select Properties 2. Select Connections in the left pane and ...
XSW: "Incompatible database version" error generated during connection test
Customer can use upgrade option on the XSW Data Management tool to upgrade the Database to the version compatible with GUI. Steps: 1. Opening the XSW Data Management GUI 2. Making sure Server Instance Name and Authentication Mode are both correct. 3. ...
XSW: "Incompatible Database Version" Wrong Error
The actual problem was found in the SQL database error log, this error was " Error occurred - schema common cannot be created." The Database User, who will be creating the database should have the sysadmin role (or similar permissions to a sysadmin ...