• RELEVANCY SCORE 3.89

    DB:3.89:Copy Authorizations From One Db To An Other sm





    I am trying to copy authorizations from one DB to an other. I have 10 databases and the users work in all 10, in order to save some time, I would like to do the mods in one and copy to the other.

    I know I could use copy express, but in this case I can not because it creates problems with the add-on that we are running and it takes an enormous amount of time to copy from/to.

    Any suggestions ?

    Thanks,

    Sophie

    DB:3.89:Copy Authorizations From One Db To An Other sm


    Hi Sophie,

    Unfortunately, the user authorization table is hidden from users.

    You can copy user authorization only when you copy complete database or using Copy Express.

    Thanks,

    Gordon

  • RELEVANCY SCORE 3.45

    DB:3.45:Copy User Authorizations pm





    Hi Experts,

    Is there a way where we can copy the User Authorizations from one database to another?

    Thanks,

    Don

    DB:3.45:Copy User Authorizations pm


    Hi Don,

    Only Copy Express is a leading candidate for the task. Make sure two db have enough things in common.

    Thanks,

    Gordon

  • RELEVANCY SCORE 3.41

    DB:3.41:Quick Copy - Not Working Correctly 1k




    Hi guys,We have a customer who has recently upgraded to SAP 9.0. They have many databases and would like to copy authorizations from one database to another. I tried using Quick Copy, but it does not do anything. I copy the authorizations to a source file.I then tried to import the source file to a target company, but nothing is imported. I tried to copy all the Administration module and it tells me that Event Sender and Integration platform need to be disconnected. I stop both services but it still says Integration platform is connected. Can anyone help?thanks,Costas

    DB:3.41:Quick Copy - Not Working Correctly 1k

    Hello, in the previous version I also faced problems with the authorizations, and document numbering.I am not 100% if it works in 9.0, all you can do is to test it and try various scenarios.I say it should work, because there is the option for the Users copy, to copy authorization as well.If there are no error messages during the import there can be a bug.

  • RELEVANCY SCORE 3.26

    DB:3.26:Copy Check Layout From One Db To Another Db z9



    is it possible to copy a check layout from companay to another company. thank you

    DB:3.26:Copy Check Layout From One Db To Another Db z9


    Thank you Gordon .

    I started using it but could figure out how to use it and then found some other instructions.

    thank you so much.

  • RELEVANCY SCORE 2.99

    DB:2.99:Resultant Set Of Structural Authorizations Logic as



    When a user is assigned multiple structural authorization profiles, what is the internal logic SAP uses to determine the resulting set of authorizations? I've been unable to find any documentation on this.

    I'm working on an issue where business units want to prevent each other from modifying the others' specific data.. but still maintain access for everyone to the shared data. It looks like we will need to assign two or more profiles to several users to accomplish this. I believe I have a workable solution, but would feel better knowing the formula SAP uses to calculate the authorizations so that I can validate the approach.

    Thank you,

    Dan Roberts

    DB:2.99:Resultant Set Of Structural Authorizations Logic as


    Hi Dan,

    I use this SAP Security guide as a reference most when I'm troubleshooting our environment. In it contains the flowcharts of checks and sequences of checks for what's going on.

    [SAP HR Authorizations 4.6c|https://websmp104.sap-ag.de/~form/sapnet?_FRAME=CONTAINER_OBJECT=011000358700001770222002E]

    Good luck, hope this is useful for you.

    Cheers,

    Dianne

  • RELEVANCY SCORE 2.98

    DB:2.98:Authorizations 7f



    Hi All!

    We are looking for a solution for our authorizations. We would like time administrators to only have access to certain employees. Cost center is too wide because some cost centers have a number of administrators. We would like to find a solution other than the time administrator field on IT0001. This field requires maintenance at the employee level and could be a large amount of maintenance.

    Is there a way that we could build an org structure just for authorizations. Use some type of structured authorizations. We currently do not have positions. That will come in a later stage.

    Any help would be great!

    Thanks,

    Jeff

    DB:2.98:Authorizations 7f


    Gupta,

    Can you tell me more about Structural Authorizations? like step by step procedure to set up and issues

    Any OSS notes available, please tell me

    Thanks in advance

    Regards

    Srinivas

  • RELEVANCY SCORE 2.91

    DB:2.91:Multiple Authorizations? sz


    Is it possible to have a single user on a computer to have multiple authorizations in iTunes? I have my laptop authorized for my iTunes purchases but we use my laptop for dj gigs. If a friend hooks up an external that has some of his purchased songs on it do i have to deauthorize my account so he can authorize his? or can one user have multiple authorizations?

    Black MacBook 2.0GHz 2.0GB Mac OS X (10.4.7)

    DB:2.91:Multiple Authorizations? sz

    Thanks for the help fellas. This has all become moot as the program I use to dj doesn't read the iTunes files. Thanks tho...

  • RELEVANCY SCORE 2.91

    DB:2.91:Authorization With Customer Exit Variable (Cp, Bt, Eq) k7



    Hi SDN-Experts,

    I have a question concerning the new authorization concept.

    I created an authorization for 0COSTCENTER which also contains the 3 special characters 0TCAACTVT, 0TCAIPROV and 0TCAVALID. I inserted a customer exit variable for 0COSTCENTER. The exit reads datasets from a db table which contains authorizations for the actual user. The authorizations have different formats, e.g. "1000", "1000;1200", "25*" etc.

    The internal table e_t_range is filled as followed in the exit:

    i eq 1000

    i bt 1000 1200

    i cp 25*

    This does not work. It works if I only use "eq" OR "cp". But not both at the same time.

    How can I achieve to use the different authorizations in the db table for the bi authorization?

    Thanks in advance...

    Joerg

  • RELEVANCY SCORE 2.90

    DB:2.90:Authorizations... ap


    Hi,How to check what authorizations has been provided to my userid.... becuase i need to check whether i had an authorizations for Broadcasting or not....Thanks

    DB:2.90:Authorizations... ap

    Hi,Run the transaction SUIM , go to roles , roles by complex selection criteria, enter role as "*" , enter you user id in column "user', and in the bottom, enter "S_RS_BCS" in authorisation object 1. If you get the output then u have the authorisation. Hope this help.Best regards,Shakeel

  • RELEVANCY SCORE 2.88

    DB:2.88:Copy Db From One Facility To The Other 99


    Can you use the browser window to copy a database item from one facility to the other?I have two windows open in Internet Explorer..one window has an eroom with a database from facility1, the other window has a different eroom open. I want to copy from window 1 the database to window 2...but it just flashes...nothing happens.We're having import problems so I can't import the eRoom. Any suggestions?Running eroom 7.2 (windows xp)

    DB:2.88:Copy Db From One Facility To The Other 99

    Hi Gene,Can you get the export of the database, or do you run into same problems with db export as with room export?

  • RELEVANCY SCORE 2.83

    DB:2.83:Large Data Copy j9


    Hi guys,

    What would be the most easiest/effecient way in terms of time,space,n/w concern while doing a 1TB of data copy (from single table growing constantly due to batch jobs running over) from one oracle DB to other (running on Linux) ?

    -- Export/Import
    -- copy via DB link
    -- ???
    -- ???

    Awaiting response,

    Laks.

    DB:2.83:Large Data Copy j9

    HI,
    so i guess that leaves you with
    either expdp or db link .

    as previous said, if you have the disk space to store the temporary expdp files, I would go with that option, doing it in parallel slaves depending what is the hardware you have (cpu especially).

    S.

  • RELEVANCY SCORE 2.82

    DB:2.82:Replication Or Copy kz


    Hello everyone!

    Can anyone tell me a easy way to copy Data from one to another DB.

    DB:2.82:Replication Or Copy kz

    Hello everyone!

    Can anyone tell me a easy way to copy Data from one to another DB.

  • RELEVANCY SCORE 2.79

    DB:2.79:Auhtorizations Issue p3



    Hello experts,

    I am implementing a project on Authorizations from scratch. All users had SAP_ALL profile, but after an audit they were told to restrict access to information. So, i am implementing their specs. In this first phase in order to please the next audit, the implementation is very simple.

    I have 4 roles, 3 to distribute by the users, and another one for the Administrators.

    So i have based my approach in this first phase in transaction level. The users filled the Excel with the transactions they use and the Roles are based on them. I inserted the transactions and generated automaticaly the authorizations. I accepted all SAP recomendations for the Authorizations and authorization object values and gave full access to the authorizations that SAP didn't knew what activities to put.

    Now i am testing the processes users will do, and i realized the following:

    Some transactions have inside them, shortcuts masked of buttons, go tos, etc that leads to other transactions users didn't mapped. Is there any table that gives me wich transactions can be called inside the transactions, so i can map every transaction users will use? Wich is the best way to get all transactions mapped?

    Another question regarding the implementation proccess:

    Am i procceeding correctly? Please be aware that, in the short term all authorizations will be much more restricted after the more detailed specs of the client.

    Thank you very much

    Regards

    John

    DB:2.79:Auhtorizations Issue p3


    Well, at least you're making progress

    For starters, please choose a more descriptive subject line the next time. Quite a few posts here are about authorization issues.

    As far as the hidden transactions are concerned, a lot of transactions will propose these additional transactions to be entered into S_TCODE by the profile generator. Another possibility is that the couples are registered in SE97 so the S_TCODE check for the called transaction is skipped anyway.

    I do not think there is a short way to find these. Testing will reveal them anyway. To avoid working through tons of error messages you can consider having your key-users go through their processes with SAP_ALL and a system trace sunning. That'll reveal all transactions started.

    Cheers

    Jurjen

  • RELEVANCY SCORE 2.79

    DB:2.79:Built A New Role With Display Authorizations In Mm jm



    Hi All,

    I have been given a task to create a role for MM (Materials Management) Display only.

    What i have done is from pfcg created a role and in the menu tab i selected copy menus from sap menu and now i have to maintain authorizations.

    when i go to authorizations tab and change role authorizations there are somany objects that need to be maintained for example Basis,controlling, FI,MM,PM,SD.

    can some one please tell me what need to be maintained and what tcodes need to be assigned to this role (for MM ).

    Many thanks for your time and help.

    Havent Been given any tcodes****

    Kind Regards,

    Vamsi.

    Edited by: vamsi koganti on Apr 8, 2008 5:53 AM

    DB:2.79:Built A New Role With Display Authorizations In Mm jm


    Hi,

    depend on what t-codes you defined, the oject class and authorization objects maybe vary.

    there is no exact predefined template for your purpose, but common authorization class that relate to MM are :

    MM_B

    MM_D

    MM_E

    MM_G

    MM_L

    MM_R

    MM_S

    MM_W

    any other object class, in example SD for SD modules depend t-codes that you have assigned.

    if you don't understand what value to be set, ask your BASIS or other functional, if they don't understand too, try to inactivate it and try to login. if you are facing unauthorized one, try /nSU53 to determine what authorization is missing.

    rgds,

    alfonsus guritno

  • RELEVANCY SCORE 2.78

    DB:2.78:Database Copy On Same Server 7z



    Hi guys,

    I want to copy the existing 6.40 system TBW to a new instance TBX on the same server. I've created all filesystems, copied the content, changed SIDs and paths in environment scripts and profiles and restored the database TBW to TBX with brdb6brt. Now my problem is to understand how to set the permissions and users correctly. the authorizations are stored in the DBM(SYSADM,SYSCTRL and SYSMAINT group) and their names contain the SID of the instance. So what do I do? Copy the db2tbw user to db2tbx and assign the "wrong" old groups to it? Or use the same user db2tbw also for db2tbx? Or is it possible to have more than one DBM per server? What are the best practices about more than one SAP DB/2 instance on one server? Any docus around?

    Regards,

    Pascal

    DB:2.78:Database Copy On Same Server 7z


    Hi Dirk,

    I restored the db successfully. Strangely in the db2diag.log wanted to "open" the source containers while creating the target containers (there were access denied per container messages). Do you have any idea what the redirected restore scripts wants on the containers of the source db (which relies on the same server), there was no single line about the source db containers in the restore script (I used the replace option of dbdb6brt)

    I found the TSM problem, you have to enter the owner of the source db to see the db images and logs on TSM.

    Regards,

    Pascal

  • RELEVANCY SCORE 2.77

    DB:2.77:Issue With Structural Authorizations And Appraisal Document p3



    Hello Experts,

    We are implementing HR Structural authorizations with context sensitive concept. We are using 2 structural profiles one for MSS and other for HR. As we are using context sensitive auth concept, we need to use P_ORGINCON object for ESS. But under P_ORGINCON in ESS role, we need to provide an SA Profile. for the same we have created another ESS SA profile and assigned to user. Now issue is when we use ESS and MSS together, i am able to see the Performance management appraisal document under ESS tab but able to see employees from other org unit. If i give only ESS and MSS with an FM assigned to object type P and Evaluation path A101 12, i am unable to see Performance management Appraisal document but able to restrict employees from other org unit.

    Please suggest us how can we over come this issue?

    Thanks in Advance...

    Jai

    DB:2.77:Issue With Structural Authorizations And Appraisal Document p3


    Hello Experts,

    We are implementing HR Structural authorizations with context sensitive concept. We are using 2 structural profiles one for MSS and other for HR. As we are using context sensitive auth concept, we need to use P_ORGINCON object for ESS. But under P_ORGINCON in ESS role, we need to provide an SA Profile. for the same we have created another ESS SA profile and assigned to user. Now issue is when we use ESS and MSS together, i am able to see the Performance management appraisal document under ESS tab but able to see employees from other org unit. If i give only ESS and MSS with an FM assigned to object type P and Evaluation path A101 12, i am unable to see Performance management Appraisal document but able to restrict employees from other org unit.

    Please suggest us how can we over come this issue?

    Thanks in Advance...

    Jai

  • RELEVANCY SCORE 2.76

    DB:2.76:Partition Api 78


    Does anybody know if there is an API, or some automated way to copy a partion from one application/db to another?

    DB:2.76:Partition Api 78

    You can't copy a partition, but you can read partitions and create partitions. It would take a considerable amount of parsing and manipulation to copy a partition.ESSCMD: PRINTPARTITIONDEFFILEMAXL: CREATE REPLICATED PARTITION ...

  • RELEVANCY SCORE 2.74

    DB:2.74:Easy Dms - Issue While Creating A Link In Private Root Folder 8a



    Hi All,

    I have the below issue in Easy DMS application.

    When user perform the below steps

    1. Login into Easy DMS application

    2. Search for a document

    3. From search results user is trying to Drag the document and place it in one of his folders (created inside Private Root Folder). When he perform the step user is getting an option to Add as link and Copy the document (this is as usual), but when user choose to any option then the Easy DMS pplication is not responding and after few mins Easy DMS logon screen is coming up and asking the user to login once again. Once user provide his login credentials then the task is getting successful.

    How do we restrict Easy DMS application to make the functionality successful without providing the login details second time. Is there any settings specific to users in EasyDMS application for Drag drop functionality.

    The issue is happening for few users only. I have checked the user authorizations and everything looks fine.with the same authorizations other users are able to perform the task without any issue.

    Please advice what could be the reason for the above issue in Easy DMS application.

    We are currently using SAP EASY DMS 7.1.4.4 (Unicode) version.

    Appreciate your help

    Regards,

    Sid.k

    DB:2.74:Easy Dms - Issue While Creating A Link In Private Root Folder 8a


    Hi Sid,

    regarding this behavior maybe the reason is that there are still some 'old' Z_EASYDMS_* function modules in your system. Could you please check this in the backend transaction SE37?

    Another reason could be that the S_TABU_RFC permission is missing for the affected users. For further information please see http://wiki.sdn.sap.com/wiki/x/UwRIF.

    Best regards,

    Christoph

  • RELEVANCY SCORE 2.74

    DB:2.74:Java Stack Not Starting Up After System Copy ca


    Hi,We have done the system copy from Production to Sandbox and we are facing an issue with the JAVA Stack not starting up.Following is the error in the SAPInst log file.INFO 2014-09-07 18:06:48.86 [iaxxbfile.cpp:538]CIaOsFile::chmod_impl(0755)Authorizations set for /usr/sap/CS0/DVEBMGS00/data/icmandir/its/lsgui/images/list/symbols.INFO 2014-09-07 18:06:50.494 [iaxxbfile.cpp:538]CIaOsFile::chmod_impl(0755)Authorizations set for /usr/sap/CS0/DVEBMGS00/data/icmandir/its/lsgui/js.INFO 2014-09-07 18:06:50.819 [iaxxbfile.cpp:538]CIaOsFile::chmod_impl(0755)Authorizations set for /usr/sap/CS0/DVEBMGS00/data/icmandir/its/lsgui/js/texts.ERROR 2014-09-07 18:06:55.22 [syxxcfsmgt.cpp:211]CSyFileSystemMgtImpl::getNode(const CSyPath path, CSyPath::NodeType nodeType) constlib=syslib module=syslibFSL-02015 Node /usr/sap/CS0/DVEBMGS00/data/stat46 does not exist.INFO 2014-09-07 18:46:32.15 [iaxxbfile.cpp:538]CIaOsFile::chmod_impl(0755)Authorizations set for /usr/sap/CS0/DVEBMGS00/work/co.sapCS0_DVEBMGS00.INFO 2014-09-07 18:46:35.895 [iaxxbfile.cpp:538]CIaOsFile::chmod_impl(0755)Authorizations set for /usr/sap/CS0/DVEBMGS00/work/dw.sapCS0_DVEBMGS00.WARNING2014-09-07 18:46:36.218CJSlibModule::writeWarning_impl()Broken link /usr/sap/CS0/DVEBMGS00/work/ig.sapCS0_DVEBMGS00 - /usr/sap/CS0/DVEBMGS00/exe/igswd_mt detected.Please guide.Thanks,CJ

    DB:2.74:Java Stack Not Starting Up After System Copy ca

    For system of the J2EE stack did you use sapinst export and import ?If the Java doesn't start then check the trace files (dev_server, std_server, bootstrap logs) present at /usr/sap/CS0/DVEBMGS00/workRegardsRB

  • RELEVANCY SCORE 2.74

    DB:2.74:Hr Ps Report In Manger Desktop 7m



    hi!

    i created a report combining hr ps data not using logical DB.

    i am trying to execute the report via manger desktop transaction PPMDT.

    the problem is that there is no authorization check done , even though the specific user has authorizations( including structural authorizations).

    how can i execute it trough PPMDT and have an authorization check?

    regards

    yifat

    DB:2.74:Hr Ps Report In Manger Desktop 7m


    What kind of HR data are you reading? How can you read HR data without reading infotypes?

    I guess the question is how do you want to keep the user to only see his organizational unit. There are two options.

    1. Code all necessary authorization checks into your program since you are not using LDB.

    2. The way that we have set up our MDT Reports is to be called via a custom function module with the following interface:

    "----"*"Local interface:

    *" IMPORTING

    *" VALUE(ACT_FCODE) LIKE MWBFCDDEF-FCODE

    *" VALUE(ACT_PLVAR) LIKE OBJEC-PLVAR OPTIONAL

    *" VALUE(ACT_OTYPE) LIKE OBJEC-OTYPE OPTIONAL

    *" VALUE(ACT_OBJID) LIKE OBJEC-REALO OPTIONAL

    *" VALUE(ACT_BEGDA) LIKE OBJEC-BEGDA DEFAULT SY-DATUM

    *" VALUE(ACT_ENDDA) LIKE OBJEC-ENDDA DEFAULT SY-DATUM

    *" EXPORTING

    *" VALUE(ACT_PROGNAME) LIKE SY-REPID

    *" VALUE(ACT_SCREEN_NO) LIKE SY-DYNNR

    *" TABLES

    *" ACT_OBJECTS STRUCTURE HRSOBID OPTIONAL

    *" EXCEPTIONS

    *" OTHERS

    *"----

    Once you create the function module it gets set up in MDT config. The table ACT_OBJECTS contains the objects passed in through manager's desktop. It should have all of the relevant PERNRs.

    However it is not recommended to rely on this to secure data. You should still code the necessary authorization checks into your code.

    Chris

  • RELEVANCY SCORE 2.73

    DB:2.73:List Of All Tables Used In Dsv z8


    hi
    is there an option to query from metadata a list of all tables used in DSV? or used in a cube?
    i saw a full project that reports metadata but that doesnt suits my authorizations. i'm talking about simply querying (the OLAP DB i believe..)
    the query select * from $system.mdschema_input_datasources just gave me a list of data sources :(
    TIA

    DB:2.73:List Of All Tables Used In Dsv z8

    hey Darren thanks for replying
    the script did not work for me, i got a syntax error near $assembly in first line
    anyway, i managed using SSAS's functionallity
    SSAS 2008 lets you generate a report with columns used just right click the DSV and Used Columns Report..
    the report includes of course the tables used
    this helped in my case because i had a few models and more important, few DSV's
    thanks

  • RELEVANCY SCORE 2.73

    DB:2.73:Workflows After Copy Db To Other Server 8x


    hi,i installed CRM 4 on a new server and copy datasets from the former DB(i wanted to run the CRM from new server) the problem is that for one of the organizations the workflows(system tasks) stoped , when i open the the wokflow process i receive in the microsoft CRM ERROR report object reference not set to an instance of an objectis there anyway to solve this (other than start over all the workflow tasks that run on the former server) 

    DB:2.73:Workflows After Copy Db To Other Server 8x

    The Update Rollups need to match before you restore the database and import the organization.  I am not sure it will work to appy the Rollups after the restore and import are complete, but you can try it.  if that doesn't work, disable the Org, drop the database, ensure Rollups match, restore the db and import the Org.  Ensure you have success at each step in the process.  Be sure to address all errors or warnings.Best Regards,
    Donna

  • RELEVANCY SCORE 2.73

    DB:2.73:How To Copy Schemas From One Database(A) To Another Database(B) ff


    Hi All,

    I have to copy the schemas from Database A onto Database B.
    I usually expdp the schema from DB A and copy the dump to other host and import it on DB B.
    Is there any other way then expdp / impdp to copy the schemas from one database to another.

    Thanks!

    DB:2.73:How To Copy Schemas From One Database(A) To Another Database(B) ff

    Ven wrote:
    Hi All,

    I have to copy the schemas from Database A onto Database B.
    I usually expdp the schema from DB A and copy the dump to other host and import it on DB B.
    Is there any other way then expdp / impdp to copy the schemas from one database to another.

    Thanks!For Network link: -

    you may also refer
    http://vishwanath-dbahelp.blogspot.in/2011/09/network-link-in-datapump.html

    along with the oracle docs

  • RELEVANCY SCORE 2.73

    DB:2.73:Deletion Of Duplicated Table Entry 3s



    Hi!

    I have executed the system copy of SAP ERP 2005 from Windows with MS SQL on Windows with SAP DB.

    According to SAP guide some entries of the DB-tables should be deleted.

    Can some one give the tcode and other technical description in order to do this?

    Thank you very much

    regards

    Thom

    DB:2.73:Deletion Of Duplicated Table Entry 3s


    Hi Thom,

    I can give you a note about deleting duplicated entries, but it is for Oracle (you know, this forum is called SAP on Oracle) so no use for MS SQL or MaxDB (or at least that is what I think9

    Also, it could be interesting that you clarify

    According to SAP guide some entries of the DB-tables should be deleted.

    There is a long time I do not do a migration, and I do not recall anything about duplicated entries.

    Can you explain in which guide have you seen it?

  • RELEVANCY SCORE 2.73

    DB:2.73:How To Fix Error Unknown Permission Type In Copy Express Authorizations ? 88



    Hi Experts

    I used copy express to copy authorizations from 1 database to another database, but there is an error which is "Unknown Permission Type", How to fix it ?

    Really appreciate your help

    Thank you

    Best Regards

    JeiMing

    DB:2.73:How To Fix Error Unknown Permission Type In Copy Express Authorizations ? 88


    Hi,

    The problem could be if you tried to update or change the

    authorizations for a superuser:

    It is not possible to change the authorizations of superusers.

    Superusers have full authorizations and permissions by default and it

    can't be changed.

    There are some points when you copy Users.

    For details, please refer to the attached note 973213.

    So, when you want to copy Users, please try the following way:

    1) Copy 'Additional Authorisations Creator' and all its dependency

    nodes, but without 'Users'.

    2) Copy 'Users'.

    Lucy Shen

  • RELEVANCY SCORE 2.72

    DB:2.72:How Can I Copy From User Permissions To Permission Group Permissions? 91



    Hello,

    I would like to start using the new Permission Groups in SAP 9.1 PL03, but I don't see an easy way to copy authorizations from a user to a new group.

    I have 50 users in 3 companies, and I would like to create a new group for Customer Service for example, and then copy the authorizations from one of my existing customer service users to the group. I would prefer not to manually set the hundreds of authorizations on the group. I also don't see that permission groups are exposed in the DI-API either so I can't do this programatically.

    Can anyone provide a best practice on how an existing customer would practically go from user permissions to group permissions without spending hours and disrupting users if it isn't done correctly.

    Thank you,

    Mike

    DB:2.72:How Can I Copy From User Permissions To Permission Group Permissions? 91


    Hello,

    I would like to start using the new Permission Groups in SAP 9.1 PL03, but I don't see an easy way to copy authorizations from a user to a new group.

    I have 50 users in 3 companies, and I would like to create a new group for Customer Service for example, and then copy the authorizations from one of my existing customer service users to the group. I would prefer not to manually set the hundreds of authorizations on the group. I also don't see that permission groups are exposed in the DI-API either so I can't do this programatically.

    Can anyone provide a best practice on how an existing customer would practically go from user permissions to group permissions without spending hours and disrupting users if it isn't done correctly.

    Thank you,

    Mike

  • RELEVANCY SCORE 2.72

    DB:2.72:Does Any One Know Where I Can Edit Authorizations/Hide Action Profiles In Charm? 3z



    Hi All,

    Do you know where we can edit the Authorizations for CHARM objects in terms of Urgent corrections, when I try to delete lets says SDJM99 from the authorizations from a Developer role, when the developer tries to do anything(meaning logon to satellite system, ect...) it will throw an unauthorized message until it's reassigned.

    OR do you guys know if we can hide certain action profiles for certain users in CHaRM? Either one would be helpful .

    Thanks Regards,

    Chris

    DB:2.72:Does Any One Know Where I Can Edit Authorizations/Hide Action Profiles In Charm? 3z


    Hi Chris,

    yes, we can make the certain actions visible to certain users, for other users the action get grayed out.

    this can be done by creating authorization keys and assign to the auth object B_USERSTAT

    Please check the attached use cases for the aut object in the below wiki area http://wiki.sdn.sap.com/wiki/display/SMAUTH/B_USERSTAT

    and the similar discussion before http://scn.sap.com/thread/1879737

    I strongly reommend you read the security guide from SAP SOLMAN 7.1, find out what is the exact role for developer and assign them.

    Thanks.

    Jansi

  • RELEVANCY SCORE 2.72

    DB:2.72:Sql Server 2005: Copy Table-Data From One Sql Db Machine (Development Machine) Into Physically Different Sql Machine Db (Production Machine) Using Tsql? am


    Hello, is it possible via TSQL to do like a SELECT INTO statement referencing the db that resideswithin thedevelopment machine into a physically different SQL machine (production machine)? Think I came across using linked servers in the
    TSQL and was wondering if other TSQL methods and if linked servers is the recommended way if someone could point to an example on how to do it, thanks in advance.

    DB:2.72:Sql Server 2005: Copy Table-Data From One Sql Db Machine (Development Machine) Into Physically Different Sql Machine Db (Production Machine) Using Tsql? am

    Hi Techresearch, Have u got the solution?? if yes, please close the tread by marking your answer.--------------------------------- Devender Bijania

  • RELEVANCY SCORE 2.71

    DB:2.71:Analysis Authorizations In Bw 3.5 99



    Hello,

    I need to create the following authorizations based on two infoobjects - country and company code.

    users can have authorization to see data from one company code with all countries and also, specific countries with one other company code... for example - company code 1000 with all countries, and company code 2000 with country = us.

    In BI 7.0 this is not a problem since the authorization work in a union mode. basically, creating an analysis authorization with the two infoobjects is enough - one for each scenario.

    Since BW 3.5 works in "join" mode, this is a problem. The only solution I figured out is two add another characteristic to the infoprovider - which is the concatenation of the two infoobjects - and then, basically create the authorization object two work on this "new"infoobject.

    Is this the only solution? couldn't there be a simple solution to this "simple"problem?

    Tomer.

    DB:2.71:Analysis Authorizations In Bw 3.5 99


    Hi,

    Those documents are not relevant. One is for BI 7.0. The second does not deal with two infoobject authorizations.

    Tomer.

  • RELEVANCY SCORE 2.71

    DB:2.71:Help Copy Tables Between Two Db Ora! f9



    HI,

    I have the necessity to copy (and periodically to modernize) the data from 10 tables on a DB Oracle under SAP on an other DB Oracle. How I can make?

    Regards.

    DB:2.71:Help Copy Tables Between Two Db Ora! f9


    Thanks,

    but the tables on the second db must be updated to the day once like can make?

  • RELEVANCY SCORE 2.71

    DB:2.71:Ess Quota Overview "Table Is Empty" cc



    Hi,

    Interesting problem....We have an SAP portal with ESS. When you go to Working Time - Quota Overview one normally gets a table displaying your time quota information.

    I have this problem that one particular user does not see his information. All he sees is an empty table with the message "table is empty". On the back-end his master data does exist since we can see it with PA30 and other custom reports. His portal authorizations as well as back-end authorizations are exactly the same all the other users who can see the information.

    Please assist.

    DB:2.71:Ess Quota Overview "Table Is Empty" cc


    Hi,

    Interesting problem....We have an SAP portal with ESS. When you go to Working Time - Quota Overview one normally gets a table displaying your time quota information.

    I have this problem that one particular user does not see his information. All he sees is an empty table with the message "table is empty". On the back-end his master data does exist since we can see it with PA30 and other custom reports. His portal authorizations as well as back-end authorizations are exactly the same all the other users who can see the information.

    Please assist.

  • RELEVANCY SCORE 2.71

    DB:2.71:Migration From Reporting Authorizations To Analysis Authorizations s7



    Hello,

    Has anybody successfully migrated from reporting authorization concept to analysis authorizations on a large scale?

    I have to define a strategy to migrate around 90,000 users and the solution proposed by SAP to use users or user groups does not seem feasible.

    Has anyone found an alternative solution to using the migration program i.e. by role at minimum or is it necessary to manually migrate all roles to analysis authorizations? The only other solution would be to continue to use reporting authorizations.

    Any feedback would be gratefully received.

    Kind Regards,

    Andy

    DB:2.71:Migration From Reporting Authorizations To Analysis Authorizations s7


    Hi,

    Thanks for your reply... I was trying to find out more about how I can migrate the current users authorizations to analysis authorizations automatically without using the program that SAP have delivered. As their solution only runs by user ID or user group, it would be almost impossible with so many users.

    Also, the authorizations would have to be created in Production which doesnt make sense.

    I was hoping there was another approach where the restrictions on Company Code defined in a role could be migrated into an analsis authorization using the Company Code characteristic.

    Regards,

    Andy

  • RELEVANCY SCORE 2.70

    DB:2.70:Generel Authorizations 7z


    Hi All,I have an issue with the SAP Business One user authorizations. I cannot seem to get the authorizations set for a user to have full access to leads, read only access for customers and no authorizations for vendors. The closest I get to the above requirement is that the user can only view leads and customers but then they cannot add leads which I require. I have also managed to get them to add leads but then they have access to update customers which is a real problem for my customer! Has anyone managed do this in SAP Business One sucessfully? Please help!

    DB:2.70:Generel Authorizations 7z

    Hi Mauricio,You're a star - Thanks!I made a couple of minor adjustments and voila!Thanks again.

  • RELEVANCY SCORE 2.69

    DB:2.69:User-Specific Problem With Alv Grid Control zx



    Hi everyone,

    I have a strange problem with an ALV grid control I have created to display a list of entities selected from a database. It is working fine for almost everybody except one user - the grid shows no entries for him though they are obviously selected from the db (when he clicks on define filter rules, the entries are shown in the F4 entry help).

    It is nor an authorization problem but rather seems to be specific to that system. It's working fine in any other system for this user.

    Has anyone ever experienced this or can give me a hint on where to find a possible solution? It must be something specific to the user in that system but I can't imagine anything except the authorizations (which are fine).

    Best regards,

    David

    DB:2.69:User-Specific Problem With Alv Grid Control zx


    I checked the coding again and found out that both grids are defined in (different) form includes - therefore sy-repid always contains the name of the development class. I have to change this and it should be working.

    Thanks again for the help.

  • RELEVANCY SCORE 2.69

    DB:2.69:Maxl Copy Object ac


    Is there a way to copy calcs, load rules, and reports from one db to another without copying the entire app or db?

    DB:2.69:Maxl Copy Object ac

    You can move files in explorer? WOW! I have a vb app that does it now, but wanted to convert it to maxl

  • RELEVANCY SCORE 2.68

    DB:2.68:User Authorizations In Sap Business One. 71



    How to set and save user authorizations to limited from super user settings.

    By unchecking the super user and changing authorizations, it is not saving.

    DB:2.68:User Authorizations In Sap Business One. 71


    Srinivas,

    Check this Below Link for User Authorisations .

    http://wiki.sdn.sap.com/wiki/display/B1/SAP+Business+One+...To+Go+-+11.+Document+Creation,+Authorizations,+and+Approvals

    1.Go to User and Uncheck the Super User Tick Mark

    2.Now Go to Authorisations and Change the Authorisations to Limited Where ever Required and Update the Authorisations

    3.If You Still not Able to Save it means then there might be some inconsistencies in DB So Try Logging a Message to SAP.

    Regards,

    Vamsi

  • RELEVANCY SCORE 2.68

    DB:2.68:How To Copy Statistics From One Partition To Other In 9i kk


    Hi,

    Can you please explain me about How to copy statistics from one partition to other partition or one DB to other DB in 9i

    Thanks

    DB:2.68:How To Copy Statistics From One Partition To Other In 9i kk

    Hi,

    copy statistics from one partition to other partition or one DB to other DB in 9iHow are you copying the partition?

    Well, you can use dbms_stats for export/import, but I've not tried it on a partition:

    http://www.dba-oracle.com/t_dbms_stats.htm

    Step 1: Create the stats_table:

    exec dbms_stats.create_stat_table(ownname = 'SYS', stattab = 'prod_stats', -
    tblspace = 'SYSTEM');

    Step 2: Gather the statistics with gather_system_stats. In this dbms_stats example, we compute histograms on all indexed columns:

    BEGIN
    dbms_stats.gather_schema_stats(
    ownname='SCOTT',
    METHOD_OPT='FOR ALL INDEXED COLUMNS SIZE SKEWONLY',
    CASCADE=TRUE,
    ESTIMATE_PERCENT=100);
    END;
    /
    Step 3: Export the stats to the prod_stats table using export_system_stats::

    exec dbms_stats.export_system_statse(ownname = 'SYS', stattab = 'prod_stats');

    Step 4: Export the stats to the prod_stats table using exp:

    exp scott/tiger file=prod_stats.dmp log=stats.log tables=prod_stats rows=yes

    Step 5: FTP to the production server:

    ftp -i prodserv . . .

    Step 6: Import the stats from the prod_stats.dmp table using the import (imp) utility:

    imp scott/tiger file=prod_stats.dmp log=stats.log tables=prod_stats rows=yes

    Step 7: We can now use the import_system_stats procedure in Oracle dbms_stats to overlay the existing CBO statistics from the smaller TEST instance:

    dbms_stats.import_system_stats('STATS_TO_MOVE');

    --------------------

    Hope this helps. . .

    Don Burleson
    Oracle Press author
    Author of Oracle Tuning: The Definitive Reference
    http://www.dba-oracle.com/bp/s_oracle_tuning_book.htm

  • RELEVANCY SCORE 2.67

    DB:2.67:Multiple Logins/Authorizations kc


    I have two iTunes accounts for purchases. I used to be able to play all songs purchased regardless of account used on my iTunes and my iPods (we have 4). Now, with the 7.0.1 update I can only play tunes purchased from one account or the other.

    I need to be able to play purchases from both accounts on the same computer and iPods. How do I do this? Can I have multiple authorizations on one computer?

    DB:2.67:Multiple Logins/Authorizations kc

    I have two iTunes accounts for purchases. I used to be able to play all songs purchased regardless of account used on my iTunes and my iPods (we have 4). Now, with the 7.0.1 update I can only play tunes purchased from one account or the other.

    I need to be able to play purchases from both accounts on the same computer and iPods. How do I do this? Can I have multiple authorizations on one computer?

  • RELEVANCY SCORE 2.67

    DB:2.67:Transfering Records From One Db To An Other On An Other Server zz


    Hi all,

    my problem is that I have to transfer some special records from one Database to an other DB on an other machine. There no problem in the testenvirontment. I send the records via an JAVA stored Proc.
    But in the realtime environment jAVA is not possible.
    Is there any other way to transfer files from one to the otehr DB?

    Greets

    Marcel

    DB:2.67:Transfering Records From One Db To An Other On An Other Server zz

    Have you looked into replication here?

    I'm not sure whether you are indicating that Java is not available in your production environment or whether you are indicating that you need to move the records in "real time". If the latter, can you define "real time" in your situation-- that can been that you need to do synchronous replication or it can mean that you need things to happen asynchronously be quickly, in which case you would need to define quickly.

    Justin
    Distributed Database Consulting, Inc.
    http://www.ddbcinc.com/askDDBC

  • RELEVANCY SCORE 2.67

    DB:2.67:Structural Authorizations 7m


    Dear Forum members, we are currently trying to use Structural Authorizations to restrict access to Quotations from Sales Organizations other than the one the user is assigned to. Here we find that when we set it up, quotations with empty organization entries are also returned. How can we prevent this from happening?Regards,Sowmiya

    DB:2.67:Structural Authorizations 7m

    Hi All We also have the problem that we would like to filter the Business Partners searches to those maintained in the Organization unit of the Sales Representative. This is not happening with the Structural Authorizations. The Structural Authorization works for the Sales Transactions though. Is there a way to do this?Regards,Sowmiya

  • RELEVANCY SCORE 2.67

    DB:2.67:Do We Need To Include 0tctauthh In Analysis Authorizations In Bi 7.0 8p



    Hello Friends,

    Upgrading from 3.5 to 7.0.

    Can any one tell me abt hierarchies.like

    Do we need to include the characterstic b0TCTAUTHH/b in analysis authorizations along with b0TCAIPROVIDER,0TCAKYFNM,0TCAVALID,0TCAACTVT/b.

    and asign hierarchy ID to it as we did in 3.5 with reporting authorizations.

    Thanks,

    RAM

    DB:2.67:Do We Need To Include 0tctauthh In Analysis Authorizations In Bi 7.0 8p


    Your question about whether to use existing 3.5 hierarchies or to create new 7.0 hierarchies is probably best answered in the /community [original link is broken]. The "error" log will specify whether 0TCTAUTHH is required.

  • RELEVANCY SCORE 2.66

    DB:2.66:Logon Issue 73



    HI,

    Iam from SAP Authorizations team. Iam having one query. One user is not able to login in central instance, it is showing an error message as you are not authorized. But the same user is able to logon from Application server.

    How to solve this issue? kindly explain.

    DB:2.66:Logon Issue 73


    Please also try to ask the user to login from a different system other than his PC. If the user is able to logn to same system application server, not into central instance, it should be a problem with sap gui. More over user is not authorized message doesn't appear while entering credentails as far I know.

    Regards,

    Gowrinadh

  • RELEVANCY SCORE 2.66

    DB:2.66:User Authorizations cs



    Where are user authorizations stored?

    I've tried using Copy Express to copy users and authorizations and I haven't been entirely pleased with the results.

    DB:2.66:User Authorizations cs


    I hope this helps !!!

    bNote 1059756 - CX: Fail to copy lots of user authorisations/b

    regards,

    tamilboy

  • RELEVANCY SCORE 2.66

    DB:2.66:Copying Authorizations Etc.. cs



    HI

    i have a requirement to copy authorizations and users and profile from one sys to another sys .

    i came to know we have a roport like rsusr002, but i am not sure ,

    plse help me clearly i mean step by step .

    thanks in advance,

    kalpana.

    DB:2.66:Copying Authorizations Etc.. cs


    If you wish to copy ALL the users and roles/profiles from one system to another, and totally replace the users and roles/profiles in the destination system, then you can do a remote user master client copy. This will only copy the user accounts, roles, and profiles. (Tcodes SCC9).

    Another option would to perform a user master export and import using SCC8.

    If however you have users and roles in the destination system that you need to keep, then it would be best to recreate the accounts manually (or using CATT ..etc..), and just "download" all the roles via PFCG, and upload them in your destination system.

    Cheers

    Shaun

  • RELEVANCY SCORE 2.65

    DB:2.65:Ess Quota Overview "Table Is Empty" ps



    Hi,

    Interesting problem....We have an SAP portal with ESS. When you go to Working Time - Quota Overview one normally gets a table displaying your time quota information.

    I have this problem that one particular user does not see his information. All he sees is an empty table with the message "table is empty". On the back-end his master data does exist since we can see it with PA30 and other custom reports. His portal authorizations as well as back-end authorizations are exactly the same all the other users who can see the information.

    Please assist.

    DB:2.65:Ess Quota Overview "Table Is Empty" ps


    HI ,

    DId u resolve you issue , iam aslo facing the same scenario as you are .

    could you plesae help me out in resloving thi sissue pls

  • RELEVANCY SCORE 2.65

    DB:2.65:Clarifications On Authorizations d8



    Hi ,

    For addressing a requirement on authorization , request advice for the below points :

    1. When an user tries to view the cost details updated in the process order - do he need CK13N transaction authorization for getting them seen?

    2. For an user to execute CK11N / CK13N - will it internally call for BOM or Master Recipe like CS03 /C203 and any other codes as it pulls data from BOM and Recipe ? meaning when we are giving authorization for a person for CK13N /CK11N - do we need to give authorization for CS03 or any other BOM relevant /recipe transactions authorizations?

    Regards,

    Madhu Kiran

    DB:2.65:Clarifications On Authorizations d8


    Hi Madhu,

    For you first question, I don't think you need access to CK13N to see the Process Order cost details.

    For the second, in a business perspective, a cost analyst person will need to have access to see production master data, material master data, procurement master data, etc. So in my expierience I never see one user with CK11N and no access to display BOMs.

    You can ask for singles test roles and check this in your development system. It is a simple test.

    Kind Regards,

    Mariano

  • RELEVANCY SCORE 2.65

    DB:2.65:Portal Iview ak



    Hi Portal gurus :

    I am a beginner in portal arena.

    I have two users , one user is able to see an iview link on the left navigation and other user can not.

    Is it portal related or backend authorizations ?

    Thank You.

    DB:2.65:Portal Iview ak


    Hi,

    If you are talking about Portal Favorites iView contents, then they are User specific:

    http://help.sap.com/saphelp_nw2004s/helpdata/en/3a/d609e5803111d5992f00508b6b8b11/frameset.htm

    So the other User should create his own contents in Portal Favorites.

    Greetings,

    Praveen Gudapati

    p.s. Points are always welcome for helpful answers

  • RELEVANCY SCORE 2.64

    DB:2.64:Copy Discounts Through Authorizations kp



    Hi,

    When copying authorizations from one user to the other, the settings for discount (sales, purchasing) are not copied. Only general discount percentage is being copied from one user to another Is this a bug or desired functionality? Can we copy sales and purchase discounts as well?

    Regards

    Kapil

    DB:2.64:Copy Discounts Through Authorizations kp


    Hi,

    When copying authorizations from one user to the other, the settings for discount (sales, purchasing) are not copied. Only general discount percentage is being copied from one user to another Is this a bug or desired functionality? Can we copy sales and purchase discounts as well?

    Regards

    Kapil

  • RELEVANCY SCORE 2.64

    DB:2.64:How Can I Quickly Edit The Policy Access Control List Of An Acl Policy? ma



    BladeLogic Server Automation Suite 8.5 SP1 P2, running on mixed Windows and Unix.

    As we expand our BladeLogic installation we are adding lots of Roles with their associated ACL Templates and ACL Policies. Most of the groups want very similar Roles, for example MX_Windows_Admin is just like US_Windows_Admin role except for the servers they can access. So to make the MX_Windows_Admin Role I just log into the Automation Console GUI with an RBAC Admin role,

    open the Roles tree,

    right click on US_Windows_Admins and select copy,

    right click on Roles and paste.

    Now I have Copy of US_Windows_Admin Role. I use the Properties pane to change its name, then open the new Role to clear the Users list. The Authorizations, Agent ACL, and Group mappings are all the same and the MX_Windows_Admin Role is ready to go.... except ... I need a matching Objects Permissions Template.

    So I go up to the ACL Templates tree and do the same sort of copy and paste to copy US_Windows_Admin_ACL_Template to MX_Windows_Admin_ACL_Template. Not difficult except that now I need a matching ACL Policy to go in the Template Access Control tab.

    So I go up to the ACL Policy tree, and do the same sort of copy and paste to copy US_Windows_Admin_ACL_Policy to MX_Windows_Admin_ACL_Policy. This is where it gets Ugly, because the ACL Policy has the Policy Access Control List tab, and that has *lots* of specific Role Authorizations, which loops me back where I started because every one of those Role Authorization has to be changed from US_Windows_Admin to MX_Windows_Admin. If it were just once I could take a few screenprints to show all of the Role Authorizations, clear them, and reproduce them in the GUI. It would be slow and error-prone, but it could be done.

    But once I'm done setting Mexico I need to set up Colombia and Brazil, and then we move to the UK and Europe....

    So my questions:

    1) Is there a pair of CLI loops that would let me copy the permissions out of one ACL Policy, edit them, and put them in another ACL Policy? It seems like there out to be, but I've spent a couple of weeks in the BLCLI documentation I've found and haven't been able to put together one that works yet.

    2) Is there a better way to do this whole process?

    Thanks,Kai

    DB:2.64:How Can I Quickly Edit The Policy Access Control List Of An Acl Policy? ma


    blcli_execute BlAclPolicy showPolicyPermissions policyName

    should dump what's in the acl policy.

    and then some sed/awk/etc to switch out the role names.

    as far as a better way...

    1 - get away from the explicit permissions and use the authorization profiles to group together specific types of access, etc 'create a package' or 'browse a server'. then you can update one object and affect everything it links to.

    2 - maintain something outside of bsa w/ the information you need and then script the creation of the roles and such. you could also script a check that all the rbac objects match your source of record so that adding some perms in to a class of roles - eg SITE_WIN_ADMINS is a single update to a csv and then a run of the script.

    3 - w/ #2 the objects are created from scratch so no chance for something you forgot to clean up.

  • RELEVANCY SCORE 2.64

    DB:2.64:Changes In Structural Authorizations Bw 7 kz



    Hi all,

    i have upgraded my BW system from 3.5 to 7.01

    now i have an issue with the structural authorizations

    i have struc. auth. on 0ORGUNIT

    and evrey employee in 0EMPLOYEE has an attribute of 0ORGUNIT.

    before in 3.5 if the attribute was empty every user in the BW could see the employee

    now in 7 if the attribute empty no user can see it.

    eve due it is an odd question, does any one knowes how to go back to the old way?

    Thanks!!!

    Or

    DB:2.64:Changes In Structural Authorizations Bw 7 kz


    Hi,

    After long days....

    First you need to adopt Analysis Authorization to provide query access irrespective of the users positional identity. Now when you transfer your HR org. structure from OLTP to OLAP then take help of those reknowned BI contents (0HR_PA* .. can't exactly recall them). I feel it would be easier for you to do some redisgn to make them available in BI rather than sticking to the old Org structure. Hope your erp has also got the latest version (but this is insignificant as HR security didn't change from 4.6 version from Org. structure point of view).

    Let us know in details of the steps which is giving you the pain. As much as i can remember we already had similar discussion earlier. Can you please give a try by searching in this forum?

    regards,

    Dipanjan

    Edited by: Dipanjan Sanpui on Feb 11, 2011 4:57 PM

  • RELEVANCY SCORE 2.64

    DB:2.64:Authorizations Vs. Menu km


    In SAP Business One 2007A PL 49. The menu options do not directly correspond to the Authorizations settings.As an example, if I want to prevent access to Business Partners - Busines Partner Reports - Customer Receivables by Customer Cross Section where do I find that in the Authorizations screen?Is there a cross reference document available that shows where to set No Auth, Read-Only, or Full Authorization for all the Menu choices?

    DB:2.64:Authorizations Vs. Menu km

    HICheck this link:https://websmp208.sap-ag.de/~form/sapnet?_FRAME=OBJECT_HIER_KEY=701100035871000529280_SCENARIO=01100035870000000183https://websmp208.sap-ag.de/~sapidb/011000358700001216762007E/HowTo_DefAut_2007A_B.pdfFor accessing this,you need s-id and password

  • RELEVANCY SCORE 2.64

    DB:2.64:How To Copy General Authorization 7f



    Hello ,

    I have 2 database with same striucture but different COA, and I want to copy the General Authorizations from one database to another. Here the SAP users are same in both the database.

    Is there any way to do the copy of General Authorizations.

    Pls let me know.

    Thanks Regards,

    Yogesh Jadav

    DB:2.64:How To Copy General Authorization 7f


    Hello,

    There might b Copy Express Add-On in Add-On Admin, install it and start the Add-On in ur Session.

    That might Help

    Thanx

  • RELEVANCY SCORE 2.63

    DB:2.63:How To Prevent A Portal User From Using The Bex Analyzer ? ax



    Hi,

    we have different type of users : most users may use the portal as well

    as the analyzer ;

    we have one special user with extended authorizations : this user

    should use the portal , where he has a limited set of queries to run

    with hardcoded filters == this user should not be able to use the

    analyzer however, since he then would be able to call all other queries

    by using the find function ;

    how can we make sure this user cannot use the analyzer , using SAP

    authorizations ?

    best regards,

    Erwin Van Giel.

    DB:2.63:How To Prevent A Portal User From Using The Bex Analyzer ? ax


    Hi,

    The solution with the S_RS_COMP seems to work fine. I have removed the full authorization, and explicitly added the (few) queries that the user needs to execute in this authorization object.

    The user can now execute these queries, and only these, from the portal and from the analyzer.

    Thanks for your help !

    best regards,

    Erwin.

  • RELEVANCY SCORE 2.63

    DB:2.63:Authorizations In Sap Business One 1m



    I'd like printing from General Ledger (Financials -- Financial Reports -- Accounting -- General Ledger) but my user don`t have authorization.

    What Subject can I have to modify its authorizations?

    Thanks!

    DB:2.63:Authorizations In Sap Business One 1m


    Make sure the user you want to assign this authorization has professional license. All other license types would not be possible to have those authorizations from Financial Module even if you assign them full rights.

    Thanks,

    Gordon

  • RELEVANCY SCORE 2.63

    DB:2.63:Using Ms Active Directory Vs. Novell Edirectory For Portal Auths 1z



    I am aware that either active directory or edirectory can be used to authenticate to the SAP portal.

    However, for authorizations in the portal, is there an advantage of one over the other? Our portal will not only use authorizations for displaying tabs, but to perform restrictions inside custom applications.

    If you had built your portal architecture (authentication and authorization) around one, how easy would it be to convert to the other?

    DB:2.63:Using Ms Active Directory Vs. Novell Edirectory For Portal Auths 1z


    Hey Mary,

    The simplest solution I can think of is to leverage an LDAP source for UME and use group memberships for authorization assignments. For example, you could use AD as a UME source, and assign Portal content to groups in AD. Users would never "live" in the Portal, they're strictly AD (LDAP) users that are members of AD groups. Since Portal roles are assigned to roups (in User Administration), only users in those group X would get Portal Role X... users in Group Y would see Role Y... etc.

    Obviously this is possible with other applications, not just Portal but het, you posted in a portal forum ;o)

    -Kevin

  • RELEVANCY SCORE 2.63

    DB:2.63:Authorizations az



    Hi All,

    I have an authorizations issue and wondering if anyone has some insight on this. I am working on an authorizations scheme based on sales organization.

    For instance, Sales Group is the sales rep and the sales office is the location. A salesman can sell into his own sales office as well as others. i.e. Rep A sold to Washington D.C (home office) as well as Seattle (another one).

    Now in terms of authorizations, a manager needs to run a report on revenue and needs to see all revenue within his sales office as well as sales his reps have done for other offices. Which means the manager for Washington needs to see 1,000,000 sold into his office as well as the 200,000 sold into Seattle. To make things further complicated, he needs to see the dollars that other reps from other offices have sold into his office. The authoriations should restrict him from seeing the other amounts. e.g. Rep B from Seattle sold 30,000 of the 1,000,000 into Washington. The manager should see the rep and only 30,000 and not the rest of his revenue.

    So far I have tried various ways using analysis authorizations but the only way to get the "OR" statement is to use virtual characteristics. I would like to avoid this due to performance reasons.

    DB:2.63:Authorizations az


    Hi Andreas,

    Thank you for the confirmation. I already implemented the BAdI and the performance has decreased although not by much.

    You are right it is mostly a query problem and a virtual characteristic did work along with an authorization variable to restrict the data.

    Regards,

    Eugene

  • RELEVANCY SCORE 2.63

    DB:2.63:Using Webdav In A Windows Powershell Script 1m



    Hello,

    I am trying to write a Windows PowerShell script to copy a file from my SharePoint site to a DB repository folder using a WEBDAV link. I am not getting it to work.

    When I copy from SharePoint to SharePoint it works. I have used my credentials on the script which has the authorizations but it still isn't working. The response error is a 500 Internal Server error.

    Any ideas?

    Has anyone done this before?

    Thanks,

    Matt

    DB:2.63:Using Webdav In A Windows Powershell Script 1m


    Using Portal Drive to create a local drive (G:) I was able to use the copy command in my script.

    Thanks,

    Matt

  • RELEVANCY SCORE 2.63

    DB:2.63:Homogenous System Copy zm



    Hi,

    I would like to do an homogenous system copy. The source system is a Windows 2003 cluster + Oracle 9.2.0.7 + SAP R/3 4.7 + Kernel 640.

    In one node I've the CI and in the other one I've the DB instance.

    My firts question is : Can I execute the sapinst process with the user sidadm if this user is local administrator ?

    And second question is : From which node I should execute the sapinst, from the DB or CI node ?

    Thank's in advanced

    DB:2.63:Homogenous System Copy zm


    Hi Francesc Segura Garcia,

    You can do it using sidadm and rin it on DB server.

    Regards

    Ashok

  • RELEVANCY SCORE 2.62

    DB:2.62:Delegating Authorizations fx



    Delegating Authorizations

    How can I make sure a person delegated to perform an Authorization task actually receives the email notification for the task?

    Delegation of Authorizations: Reminder

    In an environment in which users will be delegating Authorizations, you should use the following namespace in Authorization email templates to ensure that both the Authorizer AND the Delegate (if there is one) receive the email:

    Performer.Email, Alternate.Email

    If there is no Delegate, the email will only go to the original performer of the Authorization task.

    DB:2.62:Delegating Authorizations fx


    Delegating Authorizations

    How can I make sure a person delegated to perform an Authorization task actually receives the email notification for the task?

    Delegation of Authorizations: Reminder

    In an environment in which users will be delegating Authorizations, you should use the following namespace in Authorization email templates to ensure that both the Authorizer AND the Delegate (if there is one) receive the email:

    Performer.Email, Alternate.Email

    If there is no Delegate, the email will only go to the original performer of the Authorization task.

  • RELEVANCY SCORE 2.62

    DB:2.62:What Happens When You've Used Your 5 Authorizations? f7


    I have an older computer that I have had to re-do my operating system approximately every other month. Each time I have to do this, iTunes counts another of the 5 authorizations that I have on songs that I have purchased. I have never authorized any of my songs on other computers - it's always the same computer. So far, I've used 4 of the 5 authorizations. What happens when you use all 5? Do I have to purchase my music all over again? If that's the case, I'll never buy from the iTunes music store again (it'll end up being cheaper to just buy the CD). Help!

    DB:2.62:What Happens When You've Used Your 5 Authorizations? f7

    BM,

    When you've used all 5 authorizations you will have the option to
    b Deauthorize All
    and start over again.

    It's very important to realize you will only be able to exercise this option once a year, though. So it's important that you learn to deauthorize your computers before "re-doing" your operating system.

    See:

    http://docs.info.apple.com/article.html?artnum=93014

  • RELEVANCY SCORE 2.62

    DB:2.62:Hi ff



    HI every one can any one help me

    what are the upgradations done to roles

    and authorizations from SAP r/3 to SAP ECC 5.0

    and to ECC 6.0 i mean how we do this upgradations from

    one version to other

    DB:2.62:Hi ff


    trx Su25 and read authorisations made easy

  • RELEVANCY SCORE 2.62

    DB:2.62:Authorizations And Web Templates From 3.X To 7.X Flow zs



    hi

    i installed all including queries from business content for personal administration (PA)

    i made some customization fro existing queries, now i want publish into potal , from business content i got existing template and existing authorizations. if i want 7.x this templates and authorizations what are the steps i need to follow

    other than information broad casting can i publish report into portal in BI 7.0?

    DB:2.62:Authorizations And Web Templates From 3.X To 7.X Flow zs


    in bi 7.0 migrate ur 3.x webtemplate to BI 7.0 datasource tools-migrate

  • RELEVANCY SCORE 2.62

    DB:2.62:Private Area Not Created pm



    Hello,

    This issue is about CFolders integration with bid invitations but it is not the main point.

    I have two users (one copy of other) with roles:

    SAP_BBP_STAL_BIDDER

    SAP_CFX_USER

    SAP_EC_BBP_BIDDER

    One of them create an offer and his private area, but the other one only can see the public one.

    I review the authorizations on CFolders and they have the same, the one who can't create have Guest Authorization

    Any idea?? I think that my mistake is in authorizations, but i don't see the different.

    Best regards,

    Nacho

    DB:2.62:Private Area Not Created pm


    I found something more. It isn't depend on the user. Only a private area is create, the first supplier who creates the bid

    Regards,

    Nacho

  • RELEVANCY SCORE 2.62

    DB:2.62:Copy Data From One Instance Into Another sd


    How do i use PL/SQL to copy data from one db instance to another.

    Thanks,
    Madhu

    DB:2.62:Copy Data From One Instance Into Another sd

    may be like that ?

    insert into dbo.table (f1 , f2 , f3)
    values (select f1, f2 , f3 from dbo.table)

  • RELEVANCY SCORE 2.62

    DB:2.62:Copy Package 1p


    Hai all,

    How can I copy a package from one db to another ?

    thanks
    yusuf

    DB:2.62:Copy Package 1p

    Thanks all for your wonderful answers...

    Yusuf

  • RELEVANCY SCORE 2.62

    DB:2.62:Copy Functions And Procedures f3


    Dear all,

    I need to copy functions and packages from one db to the other.. For some reasons I cannot be able to use export..

    Is it possible to copy this though a db link ?

    Kai

    DB:2.62:Copy Functions And Procedures f3

    For some reasons I cannot be able to use export..Would be interesting to know the reason why ? ....

  • RELEVANCY SCORE 2.62

    DB:2.62:A Basic Question About Authorization Rights 7j


    I am brand new to iTunes and am confused by the authorizations for purchases from the iTunes store. Note I am running iTunes 7 on a computer running MAC OS 10.3.9, if that matters.

    My wife and I share the same iMAC but are different "users". If I purchase a song and download it into my iTunes library in my user account on the MAC and also copy it into her music library in her user account on the same MAC does that count as one or two computer authorizations against the limit?

    A second question is if I import a CD purchased at an old fashioned music store into my iTunes library and do that import as a ACC file, is that file now restricted as to how many computers can play it and burns I can make?

    DB:2.62:A Basic Question About Authorization Rights 7j

    As Niel noted - no restriction on your own rips.

    There is a restriction on how many time you can burn iTS purchases. I believe the limit is 7 - the work around is to reorder the Playlist.

    MJ

  • RELEVANCY SCORE 2.61

    DB:2.61:Security Filtering Explanation: Can You Help Me Understand This Line? 97



    Hi,

    In a discussion of security strategy of BW reporting authorization objects, the author wrote the following but I got lost over the unlined sentence.

    Can you help me understand it?

    If you have an example for the explanation, it will be great.

    Especially one has to emphasize the main property of reporting authorizations which is a result of the second reason: from the beginning, reporting authorizations do not work as a filter on a larger set of data! In contrast, the selections have to filter out first all data which are not allowed before the query is actually executed. uThis can be done with fixed filters or, much better and flexible, with variables which are of the type filled by authorizations./u This pre-filtering is the most critical point in the modelling of reports and reporting authorizations.

    Thanks.

    DB:2.61:Security Filtering Explanation: Can You Help Me Understand This Line? 97


    What the Author is trying to say is:

    If you set the rpeorting authorizations, the query will will get pre filtered before it is presented to the users".

    Explanation: You have a report which has profit centre, among others. Your Organization wants to set the authorization in such a way only the persons who are responsible for a profit centre should be granted the privelege to view their data. We set this with authorization on profit centres. When the query is executed, the OLAP checks the authorization values and presentes onlt those values for which he / she is responsible for.

    Ravi Thothadri

  • RELEVANCY SCORE 2.61

    DB:2.61:Need Load Rule To Load Members Of One Dimension 7k


    Hello,

    I made a new database. One commonality with an existing database are the members in one dimension.

    I would like to copy the members (meta data) from the existing db to the new db.

    How do I build a load rule to accomplish that?

    Thank you so much,
    Robby

    DB:2.61:Need Load Rule To Load Members Of One Dimension 7k

    If both databases are of the same type (BSO or ASO) then you could just go into EAS open both outlines and copy the dimension from one database to the other. No need for a load rule.

  • RELEVANCY SCORE 2.61

    DB:2.61:Tolerance Limit ac



    Hi

    We have two users running a transaction. One user is able to successfully execute and the other is having some problem with the same.

    I have checked the authorizations and both have the same authorizations...

    Also checked for the Tolerance limits, and the user has the tolerance limit set same as the other user in OB57.

    Is there any other place, where we assign the users ... any authorizations or tolerances .

    Thanks,

    Srik.

    DB:2.61:Tolerance Limit ac


    Hi Srikanth,

    What kind of transaction that your questioned user is not able to post.

    Check the settings in OBA3, OBA4, OBA0, and OB57.

    Most of the cases, the tolreance group key is created with BLANK code only.

    Remove any entries in OB57 for the quesntioned user.

    This might help you.

    Thanks,

    Srinu

  • RELEVANCY SCORE 2.61

    DB:2.61:Copy Attribut From One Register To Other Register zd


    Hello

    I have a litle problem with Post-Query-Trigger together with the copy function from Oracle-Forms.

    On one register i have a lot of textfield (DB-field).
    On the other register i need some of the textfield from the first register. This fields are also DB-field's. If i copy the textfield with the copy method from Form [Value copy from object], some Cursor in the Post-Query-Trigger don't work. But some textfield work so and the Cursor in the Post-Query-Trigger also. Why this and how can i copy field_XY on register_A to field_XY on register_B? The propertis of the DB-Field are identical.

    Thank's for your help

    Rene

    Email: rene.koeppel@bluewin.ch

    DB:2.61:Copy Attribut From One Register To Other Register zd

    Hello

    I have a litle problem with Post-Query-Trigger together with the copy function from Oracle-Forms.

    On one register i have a lot of textfield (DB-field).
    On the other register i need some of the textfield from the first register. This fields are also DB-field's. If i copy the textfield with the copy method from Form [Value copy from object], some Cursor in the Post-Query-Trigger don't work. But some textfield work so and the Cursor in the Post-Query-Trigger also. Why this and how can i copy field_XY on register_A to field_XY on register_B? The propertis of the DB-Field are identical.

    Thank's for your help

    Rene

    Email: rene.koeppel@bluewin.ch

  • RELEVANCY SCORE 2.61

    DB:2.61:Copy B1 User Authorizations 3a



    does anyone know if there is any easy way to copy the user authorizations from one company to another or to export user authorizations?

    Cheers

    DB:2.61:Copy B1 User Authorizations 3a


    Authorizations can be copied with Copy Express in general!

    For "System permissions" you have to keep 2 things in mind:

    a) You must exclude super users from the copy process.

    b) There are authorizations that are not covered (mostly in the Inventory and Service area); check the DI API documentation for SetSystemPermission method of the SBObob object vs. the authorizations you need...

    "User Authorizations" / additional authorizations should be copied entirely.

    I suggest that you check with SAP Support in case it wouldn't work properly.

    There's also an Expert Session available that explains how to use Copy Express - available on SAP Service Marketplace or here on SDN in the B1 E-learning section (https://www.sdn.sap.com/irj/sdn/businessone-elearning):

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/media/uuid/46d88f91-0901-0010-2097-f31d23043570

    HTH,

    Frank

    Message was edited by:

    Frank Moebius

    PS: I had given 10 points to Carlo's reply since you had received this answer that (minus some limitations) resolves your problem, but you didn't give him any points... - please don't forget to reward people who helped you out! ...and thanks for particpating in this Forum!

  • RELEVANCY SCORE 2.61

    DB:2.61:Extract Tester (Rsa3) And Authorizations fk



    We have noticed recently that the Extract Tester, tcode RSA3, does not seem to check authorizations. For example, if you test an HR extractor it does not check your SAP authorizations for that data.

    Anybody know a solution to this other than taking away the transaction?

    DB:2.61:Extract Tester (Rsa3) And Authorizations fk


    We have noticed recently that the Extract Tester, tcode RSA3, does not seem to check authorizations. For example, if you test an HR extractor it does not check your SAP authorizations for that data.

    Anybody know a solution to this other than taking away the transaction?

  • RELEVANCY SCORE 2.60

    DB:2.60:Can We Use "Structural Authorization" To Be Defined In Hr Master Data? ja



    dear Gurus,

    is it applicable if we want to have "structural authorization" to be defined in HR master data - custom infotypes?

    it seemed that structural authorization can only be defined in Personnel Planning and Development, in addition to the basic access authorizations.

    copy from spro:

    "Structural Authorization"

    This section describes the special authorizations that you can define in Personnel Planning and Development in addition to the basic access authorizations.

    looking forward to hearing from you.

    best regards, pei

    DB:2.60:Can We Use "Structural Authorization" To Be Defined In Hr Master Data? ja


    Hi Purnima,

    thanks for your kind assistance and information..

    currently in our R/3 Production feature VDSK1 has been used..

    thank GOD, today i have found other solution.. i will still need to make sure that it can be used..

    just found object authorization P_ORGINCON (HR Master Data with Context)

    we can assign structural authorization profile for HR Master Data.

    hope this can be implemented.

    thanks a lot for your attention

    best regards,

    dhenny muliawaty (pei pei)

  • RELEVANCY SCORE 2.60

    DB:2.60:Analysis Authorizations Issue (Bi 7.0) cm



    Dear Colleagues,

    I have a question regarding BI 7.0 Authorizations. What happens when a cube is created from an Infoprovider in which Company Code (to use an example) is marked as authorizations relevant, but that infobject is not used. That is, the cube gets data from that Infoprovider, but the data retrieved has nothing to do with Company Code. When a query is created from this cube, will the user be required to have authorizations for the company code of the information he's retrieving or will she/he be able to see all the information?

    Thanks in advance for your help.

    Best regards,

    CMPT

    DB:2.60:Analysis Authorizations Issue (Bi 7.0) cm


    Hello,

    I think I understand your question?

    If you have characteristic company code marked as authorization relevant...

    You have two basic info cubes, one with company code A and one without company code B.

    You have a multi cube combining characteristics from both basic cubes (including company code).

    If you execute a query written against the multi cube but extracts data only from basic cube B (without company code), will you need to have an analysis authorization with company code defined?

    If this is your question, then Yes, you do need to define company code in the authorization (assigning value # should be sufficient).

    KR

    Andy

  • RELEVANCY SCORE 2.60

    DB:2.60:Copying Between Databases fz



    I am trying to copy content of one DB table into an other DB table how can i do this?

    tables are same dadabases are different. they are oracle database.

    help!!!!SOS!!!!

    DB:2.60:Copying Between Databases fz


    Besides the standard SAP transport mechanism you could also create a so-called 'Database link' between the two DB's (see oracle help on how to do this). Then you can access the source DB from the target DB and do a statement like this:

    insert into (targettable) select * from (sourcetable)@(db-link).

    However, this is only a just-in-time copy, but one that works fast also with loads of data.

    Regards, Kai

  • RELEVANCY SCORE 2.60

    DB:2.60:Sap Portal : Authorizations Acceptance Form z1



    Hi All,

    We are thinking of automating our approval process for user authorizations.

    What we need is that any user should able to login to SAP through the internet and should be able to submit an accepted digital document of his authorizations to the approver for approval.

    Can this can be done with SAP EP only or any other interfaces are needed?. Please share the documents if any.

    Best Regards,

    DVRK

    DB:2.60:Sap Portal : Authorizations Acceptance Form z1


    Hi All,

    We are thinking of automating our approval process for user authorizations.

    What we need is that any user should able to login to SAP through the internet and should be able to submit an accepted digital document of his authorizations to the approver for approval.

    Can this can be done with SAP EP only or any other interfaces are needed?. Please share the documents if any.

    Best Regards,

    DVRK

  • RELEVANCY SCORE 2.60

    DB:2.60:Copying Workbooks From One Db To Another 8j


    I am using Disco 9 and we have to maintain database workbooks on multiple databases. Is there an easy way to copy workbooks from one db to another without having to save to network via Disco Desktop

    DB:2.60:Copying Workbooks From One Db To Another 8j

    Nigel,

    if you are using Disco 902 and want consistent EULs and workbooks across your databases, you can use the command line /all option.
    This will export both the EUL and your workbooks.

    regards

    Paul

  • RELEVANCY SCORE 2.60

    DB:2.60:Ssrs 2008 Subfolder Access Denied But Only Partly ac


    Dear all
    After removing authorizations from the root folder we have an access issue with subfolders.
    A user with seemingly proper authorizations (Content Manager, Publisher, Browser, MyReports, ReportBuilder) is able to upload reports, delete reports, run reports, shift reports to other subfolders
    But when trying to view the security properties or updatinga report e.g. by changing the data source he gets the 'Access denied' error.
    Any suggestions for the root cause of this?

    DB:2.60:Ssrs 2008 Subfolder Access Denied But Only Partly ac

    Hi Joachim,
    have you solved this issue?
    Regards,Rudolf Swiers

  • RELEVANCY SCORE 2.60

    DB:2.60:Export/Copy Db j3


     
    I had tried several methods to export data from db A to db B, both in different servers and so far only detach/attach method worked.
     
    One of the tables has an image column. Is this the cause ? Any workaround without downtime ?
     
    Please advise.
     
    TIA !

    DB:2.60:Export/Copy Db j3

    I managed to use the Copy Database Wizard via the SQL Object Management. This time round, I deselected the login and everything from the related objects went fine.
     
    TIA
     

  • RELEVANCY SCORE 2.60

    DB:2.60:How To Import All Qlikview Server Settings From One Machine To Another? fx



    Dear all,

    Is there an automated mechanism to import all qlikview server settings (tasks, document authorizations , DSCs, QVS configurations, QVWS configurations, etc) of from one machine to another?

    Could be useful to use QMS API?

    Anyone have experience?

    Thank you.

    Pablo

    DB:2.60:How To Import All Qlikview Server Settings From One Machine To Another? fx


    HI,

    For moving tasks follow this
    SCHEDULER IN QMC
    http://community.qlik.com/message/75573#75573

    Regards
    ASHFAQ

  • RELEVANCY SCORE 2.59

    DB:2.59:Changing Work Center In Pm Order Operations 79



    Hi PM Experts,

    We got two companies operating in the same SAP client. But user are properly restricted with Authorizations in terms of company codes, maintenance panning plant, maintenance plants etc, etc,

    But I noticed that in IW32, in work order operations users belonging on to one company can select(F4) work centers/maintenance plant from the other company and save orders.

    I was under the impression that org level authorizations block this. Is there a way to stop this? provision of the the relevant authorization object in this regard will be a great help.

    thanks in advance,

    Cheers

    Deepal

  • RELEVANCY SCORE 2.59

    DB:2.59:Analysis Authorization - Limitation To An Infoprovider pm



    Hi all,

    I have some questions about the authorizations in BI7.0

    I know that analysis authorizations can be limited to an infoprovider or multiprovider, but authorization variables are needed in queries so they can work properly :

    - do you have an example of code for the authorization variables ?

    - do you know if, for the same analysis authorization, sets of authorizations can be defined by queries thanks to authorization variables, e.g. a query would be restricted on object company_code, but other queries based on the same cube would not have the restriction on this object company_code.

    - do you know if a query need all the infoobjects defined in the analysis authorizations to work properly ?

    - do you know if a query that doesn't contain one of the infoobjects restricted by the analysis authorizations will however have its data restricted on the infoobject ? For instance, my analysis authorizations define that the user will only see company_code= 1000 on cube C1. If a query sitting on C1, is not containing the object company_code, does the data displayed in the query restricted to company_code = 1000 ?

    I am very grateful for your help !

    DB:2.59:Analysis Authorization - Limitation To An Infoprovider pm


    Hi all,

    I have some questions about the authorizations in BI7.0

    I know that analysis authorizations can be limited to an infoprovider or multiprovider, but authorization variables are needed in queries so they can work properly :

    - do you have an example of code for the authorization variables ?

    - do you know if, for the same analysis authorization, sets of authorizations can be defined by queries thanks to authorization variables, e.g. a query would be restricted on object company_code, but other queries based on the same cube would not have the restriction on this object company_code.

    - do you know if a query need all the infoobjects defined in the analysis authorizations to work properly ?

    - do you know if a query that doesn't contain one of the infoobjects restricted by the analysis authorizations will however have its data restricted on the infoobject ? For instance, my analysis authorizations define that the user will only see company_code= 1000 on cube C1. If a query sitting on C1, is not containing the object company_code, does the data displayed in the query restricted to company_code = 1000 ?

    I am very grateful for your help !

  • RELEVANCY SCORE 2.59

    DB:2.59:Database To Database Transfer Using Ssis Packages f9


    Hi,I have two databases and would like to use an SSIS package to copy data from one to the other. Does anyone know if SSIS provides any kind of encryption on the wire when data is copied from one database to the other.i.e. after data is read from the source DB, is it encrypted on the wire before it gets written to target DB?Thanks-Arjun

  • RELEVANCY SCORE 2.59

    DB:2.59:Thread: Copy Post Office Msgxx.Db Files 33


    Something is deleting one of the message databases on one of our post offices. (GW 8.0.2 HP2 on Windows 2003).

    Is there a way to copy just the msgxx.db files to another location, say once or twice an hour, to at least ensure that I have a recent copy of these files until I can determine what is deleting this one file (msg23.db)?

    I don\'t see a switch for using DBCOPY that will just get the post office message databases. Any other options?

    DB:2.59:Thread: Copy Post Office Msgxx.Db Files 33

    On 16.08.2011 21:21, Steven Eschenburg wrote:

    Something is deleting one of the message databases on one of our post offices.

    (GW 8.0.2 HP2 on Windows 2003).

    Is there a way to copy just the msgxx.db files to another location, say once or

    twice an hour, to at least ensure that I have a recent copy of these files until

    I can determine what is deleting this one file (msg23.db)?

    I don\'t see a switch for using DBCOPY that will just get the post office message

    databases. Any other options?

    A batch file copying it will be just fine, unless the copy process

    itself takes long. You want the target to be as fast as possible.

    Any write access to the DB while the copy happens will be blocked, *but*

    it\'ll be queued and redone later.

    Not perfect, but it *can* be done.

    CU,

    -' + '-

    Massimo Rosen

    Novell Knowledge Partner

    No emails please!

    http://www.cfc-it.de

  • RELEVANCY SCORE 2.59

    DB:2.59:Hr Authorizations - Payroll Area z9



    Hello all,

    WE have an issue with the our authorizations for our paymasters. We have paymaster A who is able to access her payroll area and also the payroll areas of the other paymaster.

    Paymaster A is our hourly person and should never see anything with the payroll reports/programs for any salaried employees. We have set up structural authorizations which is working for everything except when the paymaster runs her payroll program, posting programs or any payroll related report and programs, she is able to execute the other payroll areas.

    Does anyone have any idea how we can restrict her from running reports, programs for other payroll areas??

    Thank you in advance.

    DB:2.59:Hr Authorizations - Payroll Area z9


    Hello All,

    I was able to fix my problem with the replies I received.

    For this particular role, Paymaster Houly I used P_ORIGINCON and was able to enter the payroll area. All is working now and I want to thank you very much.

  • RELEVANCY SCORE 2.59

    DB:2.59:Why A Limit Of 5 Authorizations Per Appleid xs


    This limitation has always caused problems. We have multiple Apple devices (e.g. computer x2, Ipad, iPhone, iTouch). That is 5 authorizations right there. Which means we can not add any other computer to the authorizations (e.g Children, spouse, etc). Then you get a new computer. IF you remember to deauthorize that computer, you have to use up your year only deauthorization to that account. OR if you get a new computer and give yours to your child, you can't deauthorize that account, because well you used up the year authorizations Which means, that I can't ever use it again (for a year) to figure out why it's telling me I already have used my 5. . Although, if I count, I already have. Will this limit ever change and why the only one per year deauthorization of accounts. Being we can't see who has our authorizations, you'd think Apple would want us to manage our authorizations and clean them up by deauthorizations. Is there any way around the year only deauthorization? I can't add an account, because it says I already have my 5. I can't deauthroize because I've already used my year (this past Dec.).

    DB:2.59:Why A Limit Of 5 Authorizations Per Appleid xs

    This limitation has always caused problems. We have multiple Apple devices (e.g. computer x2, Ipad, iPhone, iTouch). That is 5 authorizations right there. Which means we can not add any other computer to the authorizations (e.g Children, spouse, etc). Then you get a new computer. IF you remember to deauthorize that computer, you have to use up your year only deauthorization to that account. OR if you get a new computer and give yours to your child, you can't deauthorize that account, because well you used up the year authorizations Which means, that I can't ever use it again (for a year) to figure out why it's telling me I already have used my 5. . Although, if I count, I already have. Will this limit ever change and why the only one per year deauthorization of accounts. Being we can't see who has our authorizations, you'd think Apple would want us to manage our authorizations and clean them up by deauthorizations. Is there any way around the year only deauthorization? I can't add an account, because it says I already have my 5. I can't deauthroize because I've already used my year (this past Dec.).

  • RELEVANCY SCORE 2.59

    DB:2.59:Generation Of Structural Authorizations With 0orgunit Nodename Root_H fc



    Hi gurus!

    I have loaded data to DSO 0PA_DS02 and 0PA_DS03 and generated HR-authorizations to users in BI.

    Our problem is that if a user has both structural authorizations and SAP_ALL -profile in HR-client, there will be two rows in a profile in BI for info-object 0TCTAUTHH. One is for the node of the hierarchy he or she has been given structural authorizations for and the other is for ROOT_H.

    Together these doesn't seem to work. If I delete the records in 0PA_DS03 with value 3 for 0TCTATYPE and generate the authorizations, everything works fine.

    What might affect this as in a another BI-system this works with similar records in 0PA_DS02 and 0PA_DS03? To my knowledge two different profiles should be created, one for structural authorizations and the other based in sap_all -rights (starting with T-MD)?

    Any ideas?

    Best regards

    Sari

    DB:2.59:Generation Of Structural Authorizations With 0orgunit Nodename Root_H fc


    Hi!

    This issue was resolved when I noticed that the user that had the incorrect authorization, had sap_all rights in one HR-client and structural authorizations in another HR-client. Both clients are source systems to one BI-system. When we removed the sap_all authorization from one HR-client, structural authorizations were created correctly in BW system. Anyway, it seems that generation of BI structural authorizations can't handle this kind of situation. If both authorizations are in one HR-client, generation works fine.

    Sari

  • RELEVANCY SCORE 2.58

    DB:2.58:Hr-Specific Structural Authorizations In Bi. 1d



    Hi,

    In SAP BI HR Implementation there are two main ways to set up authorizations for SAP Human Resources. We can set up general authorizations that are based on the SAP-wide authorization concept or we can set up HR-specific structural authorizations that check by organizational assignment if a user is authorized to perform an activity.

    Can any one update me on what are advantages disadvantages on implementing HR-specific structural authorizations in BI.

    Thanks

    DB:2.58:Hr-Specific Structural Authorizations In Bi. 1d


    Hi Sony,

    This may help you:----

    HR Authorization: In a nutshell...

    http://help.sap.com/saphelp_nw04/helpdata/en/56/25dc886b0611d5b2f50050da4c74dc/frameset.htm

    Regards,

    Suman

  • RELEVANCY SCORE 2.58

    DB:2.58:Block Certain User From Viewing Some Gl Accounts sc



    Hello experts

    I have a requirement from Business of blocking one user from accessing to a few accounts. That is not possible using General Authorizations. Is there a way to achieve that requirement?

    I have though on Additional authorizations and Transaction Notification, but Additional authorizations seems to be based on Forms ID witch make it useless to my purpose and I am not sure if TN can be used to prevent an user from viewing.

    Regards

    DB:2.58:Block Certain User From Viewing Some Gl Accounts sc


    Hi,

    For some accounts that can't be accessed and used by some users, you can tick the confidential field in COA for the accounts and in the authorizations window -- Access to Confidential Accounts, you must choose no authorization

    If this functionality can' solve your problem, you must use SDK code to hide the field and prevent user to use it.

    Jimmy

  • RELEVANCY SCORE 2.58

    DB:2.58:Authorizations To Pull Idoc Metadata From An R3 System 91



    All,

    We are moving into production and we need the list of authorizations / Profiles / Roles needed to pull the IDOC metadata from an R3 system in IDX2 in XI as the client wants only the corresponding authorization roles to be assigned to the RFC( SM59) User in the Production System.

    Does any one have list of such authroizations? Any help in this is appreciated.

    Regards,

    Bhavesh

    DB:2.58:Authorizations To Pull Idoc Metadata From An R3 System 91


    All,

    Implemented note: 837595 's authroizations did the trick. Thanks to michal..!!

    Regards,

    Bhavesh

  • RELEVANCY SCORE 2.58

    DB:2.58:Copying A Table From One Db To Another Db pa


    How can I copy (data and definition) a table from one DB to another DB ?
     
    I will create relations from the copied table to some new tables in the new DB for testing.
     
     

    DB:2.58:Copying A Table From One Db To Another Db pa

    Hello,
     
    The solution of Deepak is ( according to me ) one of the better ones ( and one of the easiest to use ), except in one case :if your our instances are Sql Server Express 2005 because this edition is not shipped with the import/export wizard
    ( no Sql Server Agent and no import/export wizard )
     
    Have a nice day
     
    PS : with the prefered blogs of Deepak, i found that link
    http://experiencing-sql-server-2008.blogspot.com/2008/09/finally-microsoft-has-decided-to.html
    It's working for Sql Server Express 2008 but i don't know whether it is useable with Sql Server 2005 Express

  • RELEVANCY SCORE 2.58

    DB:2.58:Rsecadmin - Generation Of Authorizations 1j



    Hi Gurus,

    i created an ODS object for generating and assigning the authorizations to the users. After filling this ODS I put the technical name of that into "flat authorizations" and into "authorized user assignment" (RSECADMIN). After I pushed "start generation" in the generation log everything was green, say every authorization was successful generated AND assigned to the relevant users. BUT checking the authorizations for each user in SU01 I do not find these generated auth.s assigned under "profiles". What could be the problem?

    (Info: generation from the same ODS object has worked perfect with RSSM.)

    Thx.

    DB:2.58:Rsecadmin - Generation Of Authorizations 1j


    Hi,

    The generation part I was refering to was the generation of migrated profiles from 3.5 to 7 which is done by rsec_migration.

    Once you have the system in analysis authorization generally it would be easy to make changes and create auth objects and assign it to users or roles.

    Gokul

  • RELEVANCY SCORE 2.58

    DB:2.58:Se14 Errors After Local Client Copy jm



    Ran a SCCL on a system that had just been refreshed from PRD. The

    client copy failed with all these error messages for each file.

    Client copy was from 100 to 210 SAP_ALL profile, users from 100.

    ECC6.0 , kernel 700 #309 on an IBM i v7r1

    Never seen this one before. Anyone else?

    Thanks

    From SCC3 logs

    WTYV_IMRG LO-WTY DB Inconsistency (See SE14)

    WTY_BP1 IS-A-WTY DB Inconsistency (See SE14)

    WTY_COND_ACCOUNT LO-WTY DB Inconsistency (See SE14)

    WTY_FIELD_ATTR1 LO-WTY DB Inconsistency (See SE14)

    WTY_OBJNR_INDEX LO-WTY DB Inconsistency (See SE14)

    WTY_PARTNER_TAB LO-WTY DB Inconsistency (See SE14)

    WTY_RCLHST LO-WTY DB Inconsistency (See SE14)

    WTY_RCLOBJ LO-WTY DB Inconsistency (See SE14)

    WVFB SD-POS DB Inconsistency (See SE14)

    WVFB2 SD-POS DB Inconsistency (See SE14)

    WWKK LO-MD-RPC DB Inconsistency (See SE14)

    WWKP LO-MD-RPC DB Inconsistency (See SE14)

    WWKT LO-MD-RPC DB Inconsistency (See SE14)

    WWMI LO-MD-PC DB Inconsistency (See SE14)

    WWMIT LO-MD-PC DB Inconsistency (See SE14)

    WWMV LO-MD-PC DB Inconsistency (See SE14)

    WWVT LO-MD-PC DB Inconsistency (See SE14)

    WYT1 LO-MD-BP-VM DB Inconsistency (See SE14)

    WYT1T LO-MD-BP-VM DB Inconsistency (See SE14)

    WYT2 LO-MD-BP-VM DB Inconsistency (See SE14)

    WYT2M LO DB Inconsistency (See SE14)

    WYT3 LO-MD-BP-VM DB Inconsistency (See SE14)

    WYT4 LO-MD-BP-VM DB Inconsistency (See SE14)

    WYT5 LO-MD-BP-VM DB Inconsistency (See SE14)

    WYT6 LO-MD-BP-VM DB Inconsistency (See SE14)

    ZACT_BREAKUP DB Inconsistency (See SE14)

    ZACT_HEADER DB Inconsistency (See SE14)

    ZDTC DB Inconsistency (See SE14)

    DB:2.58:Se14 Errors After Local Client Copy jm


    Hi Matt,

    Depending on the method of your refresh your systables might have become inconsistent. AS4FIXFILE is a tool to fix this. The default settings of the command should be good in this case.

    Hope that helps.

    Thomas

  • RELEVANCY SCORE 2.58

    DB:2.58:Tcode : Sp02 Authorization Proposals From Su24 s1



    Hi Gurus,

    I have to create a role with access to some tcodes. One of them is : SP02. When I insert the tcode in the menu of the role , in the authorizations the system gives me many Object Authorizations:

    S_ADMI_FCD

    S_SPO_ACT

    S_SPO_DEV

    S_SPO_PAGE.

    Which are the values I have to put in the fields of Object Authorizations?

    Is there a report , from a tcode gives me the value of the object authorizations?

    Is there a report to view from an object authorization in which role is used (this I found it) but also it show me for each role which is the object authorizations and its value? ( for example in ALV Grid)

    Best regards

    Vanessa

    Edited by: Julius Bussche on Mar 30, 2010 8:02 PM

    Subject title made more meaningfull for you...

    DB:2.58:Tcode : Sp02 Authorization Proposals From Su24 s1


    Hi Sun

    Thank you. About SU24 in 4.6B is different from the other release, I see the object authorizations like "Y" ok but when I create a role no Object authorizations I have in the role , I don't undesrtand why , because in the other release I have not this problem...,

    so what I have to do insert manually?

  • RELEVANCY SCORE 2.57

    DB:2.57:Bps Authorization dk


    Hi all gurus,I am struggling with BW-BPS, in Variable, there is one field called Replacement Type and there is one value "Authorization". I read the help and it says: "With this replacement type the system automatically determines those characteristic values for which the user logged onto the system has an authorization, and allows the user to make a selection from those values. The authorizations used here are the reporting authorizations from the BW system. This has the advantage that authorizations in reporting are automatically consistent with authorizations in planning, without any extra Customizing effort. " Anyone has idea how to configure this to make it worked? Thanks.

    DB:2.57:Bps Authorization dk

    Hello,, Mary HuangIs it the case with the analysis authorizations too ?When we did in BPS 3.5 with analysis authorizations, it is giving the error with ' More than 10,000 values selected for the variable '.What will be solution to this kind of problem ?-Regards-Venkat

  • RELEVANCY SCORE 2.57

    DB:2.57:How To Replicate Applications c9


    Scenario: Two database servers with one schema to replicate from one server to the other (one-way replication).

    On both servers we have APEX set up. We can copy the applications (export/import), but we would prefer to have a replication-like scenario, where changes to the application on the main DB are replicated to the copy DB.

    How to set this up?

    DB:2.57:How To Replicate Applications c9

    I have two identical servers, server A and server B, both set up with the same version of Oracle and APEX. Is it safe to say that if you export

    1 - the APEX030200 schema from server A
    2 - as well as the schema containing the tables you would like to use from server A

    and import #1 and #2 into the DB on server B, you could replicate the APEX application in question???

  • RELEVANCY SCORE 2.57

    DB:2.57:"Too Many Authorizations" dj



    How do I reset the number of authorizations back to one. Only one of my authorizations will be used as the others were on old iPads I no longer use

    DB:2.57:"Too Many Authorizations" dj


    i'm not sure what adobe apps you installed on an ipad but normally, before uninstalling an unused app, you open the app and click helpdeactivate.

    if you no longer can open the adobe app, contact adobe support for an activation reset, http://helpx.adobe.com/contact.html?product=flashtopic=using-my-product-or-service

  • RELEVANCY SCORE 2.57

    DB:2.57:Authorizations After Copying Query ca



    Hi Experts!

    I've copied some enduser-queries from one InfoProvider to an other InfoProvider using RSZC.

    That worked really fine.

    Now the enduser wants to maintain the new query - but isn't allowed to do so because the owner (and last change of course) is me (checking properties of the query in the QueryDesigner).

    The enduser is not allowed to use transaction RSZC, so he can't copy his queries by himself.

    Can I change the owner from my userID to another userID?

    Thanks in advance!

    DB:2.57:Authorizations After Copying Query ca


    That may be because your enduser doesn't have authorization to create or change queries.

    Either give user authorization or you maintain it and allow the enduser to use(execute) it.

  • RELEVANCY SCORE 2.57

    DB:2.57:Copying App/Db From A Server To Another px


    What is the best solution to copy an app/database from a machine to another (Windows servers)... (I don't want to copy ALL app/db from the first server, just one of them)Copying files ?Export/Import ?thanxs for your advices...Mat.

    DB:2.57:Copying App/Db From A Server To Another px

    Depending on what version of Essbase you have, you may be able to use Essbase Administrative Services. It has the ability to copy selected apps/dbs across servers, without the hassle of copying individual objects, etc.The downside - you will need to be running at least Essbase 6.2 and it does not copy the data. However, you can export/import the data onto the new server.If you are using an older version of Essbase, you will need to do a more manual process. The most reliable approach is to create the apps/dbs you want on the new server with app man. Then, open the outlines from the source server, and do a File / Save As over top of the new ones. Objects such as calcs, rules and reports can just be copied as normal files into the database directories. You can copy the pag and .ind files as well, but I would recommend re-loading and calcing the new databases from scratch.Hope that helps.Regards,Jade----------------------------------Jade ColeSenior Business Intelligence ConsultantClarity Systemsjcole@claritysystems.comwww.claritysystems.com

  • RELEVANCY SCORE 2.57

    DB:2.57:Authorizations Issue ms



    Hello experts,

    I am implementing a project on Authorizations from scratch. All users had SAP_ALL profile, but after an audit they were told to restrict access to information. So, i am implementing their specs. In this first phase in order to please the next audit, the implementation is very simple.

    I have 4 roles, 3 to distribute by the users, and another one for the Administrators.

    So i have based my approach in this first phase in transaction level. The users filled the Excel with the transactions they use and the Roles are based on them. I inserted the transactions and generated automaticaly the authorizations. I accepted all SAP recomendations for the Authorizations and authorization object values and gave full access to the authorizations that SAP didn't knew what activities to put.

    Now i am testing the processes users will do, and i realized the following:

    Some transactions have inside them, shortcuts masked of buttons, go tos, etc that leads to other transactions users didn't mapped. Is there any table that gives me wich transactions can be called inside the transactions, so i can map every transaction users will use? Wich is the best way to get all transactions mapped?

    Another question regarding the implementation proccess:

    Am i procceeding correctly? Please be aware that, in the short term all authorizations will be much more restricted after the more detailed specs of the client.

    Thank you very much

    Regards

    John

    DB:2.57:Authorizations Issue ms


    Hi Mylene,

    Thank you very much for the reply. I guess i will, either write again the question on the forum you said or ask a moderator to change it.

    As for the issue regarding the authorizations, i'll follow your advice and turn the trace on. There is only one small detail, there are around 700 transactions that i must trace. I guess a lot of work will be done for the next phase of the project.

    Thanks

  • RELEVANCY SCORE 2.57

    DB:2.57:How To Copy An Ordimage From One Db Instance To Another Instance 8m


    Hello,

    I need to copy a table with ORDImage columns from one DB to a different DB in a global/distributed transaction. What is the best way to to this:

    Do I really need to do the "insert empty ORDImage, select for update, Load BLOB data into ORDImage Proxy, update" cycle for inserting the ORDImage in the target DB or is there a better way?

    Pete

    DB:2.57:How To Copy An Ordimage From One Db Instance To Another Instance 8m

    Hello,

    I need to copy a table with ORDImage columns from one DB to a different DB in a global/distributed transaction. What is the best way to to this:

    Do I really need to do the "insert empty ORDImage, select for update, Load BLOB data into ORDImage Proxy, update" cycle for inserting the ORDImage in the target DB or is there a better way?

    Pete