User Security

[Former Member]

Hi All,

Is there is any standard report to extract user security information from the admin Console?

We have a load balancer server connected to 6 individual servers.

Thanks,

BI

[Former Member]

Hi,

Please mention the version of BPC. Its easier to respond.

In the MS version, you can create a security report, or can export the details from the security tables.

In the NW version, you can create security audit reports or there is a how to guide which will help you to export the security settings.

Hope this helps.

[Former Member]

Hi BI,

if you work on BPC MS (as written in the last mails) remember that there is a specific forum http://scn.sap.com/community/epm/planning-and-consolidations-for-microsoft also for NW

http://scn.sap.com/community/epm/planning-and-consolidations-for-netweaver

In MS as Nilanjan wrote you have very simple and poor security report on admin console under security section, you can have some information also from Management Console this have a lot of information about the system and it's very useful for admin team, if you don't have it installed please see

http://scn.sap.com/docs/DOC-19983

http://scn.sap.com/docs/DOC-4167

or you can build an excel with vb code to extract the data you need or a Query on SSIS reading the security tables

Kind regards

     Roberto

[Former Member]

Hi Roberto/Nilanjan

Do you have any sample VBA code or macro that can be used for extracting user security from SQL server tables and what are the requirements for this?

Thanks

BI

[Former Member]

Hi,

the tables for security involved are

[dbo].[Profiles]  Member Access Profiles

[dbo].[tblUsers]  users

[dbo].[Teams]   teams

[dbo].[UserProfile]

[dbo].[UserTeamAssign]

[dbo].[UserTeamProfileAssign]

I don't have a query for this but you can add on an excel worksheet a module with in the AFTER_EXPAND call a subroutine that has something like

(outside the sub)

Public WBConn As WorkbookConnection

Public OLEDBConn As OLEDBConnection

Public CommandText As Variant

Public SQLSelect As Variant

(inside the sub)

SQLSelect = "SELECT ... (your select, you can prepare this query in SSMS) ...

If Not IsEmpty(OLEDBConn) Then
    For j = 1 To ThisWorkbook.Connections.Count
        If ThisWorkbook.Connections.Item(j).Name = "your connection parameters ...." Then

            Set WBConn = ThisWorkbook.Connections.Item(j)

            If IsObject(WBConn.OLEDBConnection) Then
                Set OLEDBConn = WBConn.OLEDBConnection
            End If
            Exit For
        End If
    Next j
End If

OLEDBConn.CommandText = CommandText
OLEDBConn.Refresh

Kind regards

     Roberto