topic Re: User Security in Application Development and Automation Discussions

User Security

Former Member — Sun, 27 Jan 2013 19:45:38 GMT

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,

Re: User Security

Former Member — Mon, 28 Jan 2013 09:17:36 GMT

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.

Re: User Security

Former Member — Mon, 28 Jan 2013 11:23:42 GMT

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

Re: User Security

Former Member — Wed, 30 Jan 2013 17:58:19 GMT

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

Re: User Security

Former Member — Wed, 30 Jan 2013 18:20:12 GMT

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