Skip to Content
avatar image
Former Member

How can you restrict a user to access only one database which has been assigned to Him or Her only.

How can you restrict a user to access only one database which has been assigned to Him or Her only without Viewing the others databases in SAP Business One on the Choose Company Window.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 12, 2017 at 01:28 PM

    Hi Janvier,

    Basically, List of DB details are stored into the SBO-Common DB of SRGC table or exec TmSp_GetCompList, but their is not option of User wise setting, For more details find the below query for your reference.

    select * from SRGC

    exec TmSp_GetCompList

    SELECT * FROM [SBO-COMMON].[DBO].[SRGC]

    For this enhancement you inbuild mechanism for refresh list of tables with user wise (same as in login screen)

    Rgds,

    Kamlesh Naware

    Add comment
    10|10000 characters needed characters exceeded