Parashuram_D365 F&O

Whenever we are trying to restore DB from PROD to dev instance. After DB restore sometimes we don't have admin access in dev instance and we can't access all Dev instance module/data or we don't have super admin access.  To access all module/table/data in dev instance we required Admin role. We can assign admin role using SQL script.  The following script would help us to add admin/any role using SQL Execute following script to know role specific "RecId"     Select Recid , * from SecurityRole where name like 'system%'     Run following script to know what role are assigned to specific user select * from SECURITYUSERROLE where user_ like 'paras%' Here I want to add "System administrator" & "System user" role to user level. Following script will help to add additional role on specific user. insert into SECURITYUSERROLE(SECURITYROLE,USER_, ASSIGNMENTSTATUS,ASSIGNMENTMODE) values (162,'parashuram',1,1) insert into SECURI...

  DB restore from PROD to Sandbox and  Sandbox  to Dev box   1. PROD to UAT DB restore:       Follow following link to restore DB from PROD to Sandbox        https://parashuramd365fo.blogspot.com/2023/06/refresh-database-from-production.html   2. UAT/Sandbox to Dev box DB restore:      2.1 . Export DB from LCS to the Asset Library           Login LCS - Sand box environment full details page, use Maintain > move database > Select export and start   2.2. This will export DB and stored on asset library. Navigate to the Asset Library > Database Backup > Select uploaded exported backup and save to local folder (Let's supposed save into D://DBBackup/) 2.3.  Prepare for DB import a. Log into the target environment using a RDC b. Download the latest SQL package.exe with the Windows .Net Core zip package Use following link to download and install SQL...