This discussion is archived
7 Replies Latest reply: Feb 24, 2011 10:38 PM by prathap_k RSS

Security Export and Copy???

prathap_k Explorer
Currently Being Moderated
Hi All,

We have to export the security file to current server and copy to another server.
We are exporting security file using EXPORT command in MaxL.

Now we need to copy the security file to another server(not manually), that we need to schedule for every day or week.
Because we are keeping both server in Sync.
Is it possible to copy the file to another server?

If possible Can you please advice any way to write script for the above.

Thanks,
Prathap
  • 1. Re: Security Export and Copy???
    Srinivas Bobbala Expert
    Currently Being Moderated
    Maxl export will Writes the contents of the Essbase security file (essbase.sec) to a readable, text file (ASCII format) on the system where Essbase Server resides.
    Exporting the contents of the Essbase security file is useful when you want to review the security information for an Essbase Server instance.
    It is not helpful in migrating the security.

    Better you can extract the users, groups and filter information using maxl commands.
    Generate maxl scripts to redefine the security in the new server and execute them.
    Once both are sync, you can replicate the activities after so that both servers are in sync consistently.
  • 2. Re: Security Export and Copy???
    prathap_k Explorer
    Currently Being Moderated
    Hi Srinivas,

    Can you please let me know how to extract users, groups, and filter information and how to redefine in another server using MaxL?

    Thanks,
    Prathap
  • 3. Re: Security Export and Copy???
    Srinivas Bobbala Expert
    Currently Being Moderated
    Collect all the required information into a spool file using below maxl commands.

    display user in group;
    display filter row on databse <<appname>>.<<dbname>>;
    display privilege group all;
    display privilege user all;

    By pushing this spool files into excel, we can easily write Maxl scripts to define security in any server.
  • 4. Re: Security Export and Copy???
    TimG Guru
    Currently Being Moderated
    As Srinivas says, you will want to parse the output of your 'display' commands on the source system into 'create' and 'grant' commands to run against the target system. Since the easiest way of staying in sync is to run this kind of process on a schedule, you could also automate the parse / script creation with the batch tool of your choice rather than using Excel.

    You might want to look at whether Life Cycle Management will do what you want on security - maybe you could save yourself reinventing the wheel (I don't know).
  • 5. Re: Security Export and Copy???
    prathap_k Explorer
    Currently Being Moderated
    I have all these excel files.
    Now can you please let me know how can i define in another server.

    Thanks,
    Prathap
  • 6. Re: Security Export and Copy???
    TimG Guru
    Currently Being Moderated
    For example, lets say you have run the command 'display group all' on your source system.

    This will have produced an output containing two columns, group name and group description, which you have transferred to Excel. If you haven't already done so, use 'Text to Columns' in Excel so that each field from the output has its own column in Excel.

    So now the name and description output from 'display group all' is sitting in column A and B of an Excel sheet. Suppose it looks like this:

    MyGroup1 Users
    MyGroup2 Superusers
    MyGroup3 Administrators

    Next you would create a formula in (e.g.) column C, something like this (untested, but you get the idea):

    ="create or replace group " & A1 & " comment '" & B1 "';"

    This produces output like the following which you copy and paste to create a new MaxL script...

    create or replace group MyGroup1 comment 'Users';
    create or replace group MyGroup2 comment 'Superusers';
    create or replace group MyGroup3 comment 'Administrators';

    ...to run against your target system.

    You will need to repeat this process for each 'display' command - groups, users, filters, filter rows, privileges etc. The specifics of the 'display' output and the syntax of the associated 'create' or 'grant' statements can be found in the MaxL section of the Essbase Technical Reference.
  • 7. Re: Security Export and Copy???
    prathap_k Explorer
    Currently Being Moderated
    Hi,

    I have exported to Excel sheets and tried to restore.
    While making excel sheet to restore i found something like for some columns there is no full data, data is limited to some characters(19) only.


    native://DN=cn=911, (here some more text is there but it is not exported to excel, this is happened for 3 files)

    in the above some text is missing, can you please let me know how to overcome this issue.

    Thanks,
    Prathap

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points