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

Hide a company to a windows group connect with trusted connection

I mean, how can I do, to create two groups in the windows active directory, and do users member of the first group and other to the second groups.

Now, when a user from the first group connect with client sap b1 with trusted connections doesn't see all companies (databases) but only those that I decide. The same thinks with the second group.

I don't want to use the 'sa' connections, because in the sap b1 8.8 the connections will be on server.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 04, 2009 at 08:10 AM

    Not sure if understood correctly.

    If you want to assign to each user only specific companies and you are using trusted connection to sql, you may modify

    tmsp_getcomplist stored procedure in sbo_common for example as

    USE [SBO-COMMON]
    GO
    /****** Object:  StoredProcedure [dbo].[TmSp_GetCompList]    Script Date: 09/04/2009 10:01:56 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER proc [dbo].[TmSp_GetCompList]
     --With Encryption 
    as
    begin
      set nocount on
      declare @comps int
      set @comps = 0
    
      select @comps = count(1) from SRGC
      if (@comps <= 0)
      begin
    	exec TmSp_RefreshCompList
      end
    
    declare @user as nvarchar(100)
     SELECT @user = SYSTEM_USER
    
      select * from SRGC
    	 where dbUser =   convert(varchar(50), CURRENT_USER)
    and
    (@user <> 'John' or (@user = 'John' and dbname = 'Demo') )
    
    
    end

    User John in this example will wee only demo company and the rest users will see all companies. Hope it helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2009 at 03:47 PM

    next question

    Add a comment
    10|10000 characters needed characters exceeded

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.