Skip to Content
author's profile photo Former Member
Former Member

Databases Shown in the "Choose Company" Window

Hallo Everybody,

did someone know, how to adjust the displayed Databases in the "Choose Company" Window on the Business One Start Up.

Our Problem is: We have serveral Databases for different User on the same Database Server.

But, for instance, the people from France should only see the France-Database

and the people from the USA should only see the American Database.

But for now, they can see all Databases.

And a funny thing is, that they can only see actual B1-Databases.

If i create an empty Test-Database, just for fun, noone can see it.

Did anybody know, how to controll the shown databases or where can i adjust this options.

Thanks and best Regards,

Sebastian

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 08, 2011 at 09:43 AM

    Hello

    1. There is no solution for that, you cannot filter the list of the databases by localizations. SOlutino for this: The country users can logon only the country specific database. Eg if the same username exists in different databases in different countries, you may change the passwords 😊

    2. You must click refresh button to refresh the list of the databases.

    Regards

    János

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Sebastian,

      If you set up Windows Authentication on your SQL Server then you can control which companies users see in the list. This is standard SBO functionality but requires knowledge of SQL security to set it up.

      What you have to do (I'm assuming you are running SBO 8.8 or higher with a MS SQL backend):

      Note: DON'T do this on your production system until you've tested it fully on a separate test system.

      1) On your network, create 2 new Windows Groups (eg 'SBO Users France' and 'SBO Users US') and add the Windows accounts of SBO users to the relevant group (some users can be added to both groups if they need to access both companies).

      2) In SQL Studio Management, go to the Security section and create new logins for these Windows Groups. For the US group, grant dbowner privileges to SBO-COMMON and the US company db. For the French group, grant dbowner privileges to SBO-COMMON and the French company.

      3) In the SAP License Manager, open Settings and go to the Configure Security window and tick the option 'Use Trusted Connection'. Stop and restart the license service.

      4) Log in to a workstation (or terminal server) as a US user and go to the Choose Company screen and you should see just the US company. Log off and log back in to Windows as a French user and you should see just the French company.

      For information, when a user clicks on the Refresh button on the Choose Company screen this triggers a stored procedure in SBO-COMMON. The proc searches for all user databases on the SQL server which have a table named CINF. SBO assumes that if this table exists then the database is a SBO company database. The list of databases is then updated in the SRGC table in SBO-COMMON. This data should not be manually altered.

      Kind Regards,

      Owen

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.