Add security role "admin" on user in Dev environment using SQL/X++

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 SECURITYUSERROLE(SECURITYROLE,USER_, ASSIGNMENTSTATUS,ASSIGNMENTMODE) values (8,'parashuram',1,1)

Now user have "System administrator" and "System user" role access and he/she super admin now.






Comments

Post a Comment

Popular posts from this blog

Execute D365 F&O SSRS report with parameter and upload report output on Azure blob storage using X++

Image
 Execute D365 F&O SSRS report with parameter and upload report output on Azure blob storage using X++ Steps: 1. Create controller class and execute SSRS report with parameter 2. Create Azure storage on Azure 3. Create Azure storage containers and folder to store report output 4. Get Azure connection key to establish connection between D365 F&O and Azure storage 5. Convert SSRS report output into byte stream 6. Upload byte stream to azure storage How to create Azure storage, containers and folder and get Azure connection key? Login to https://portal.azure.com Go to Storage account --> Storage browser --> Blob containers How to get  Connection string ? Go to Storage account --> Security + networking --> Access Key --> Connection string Code: using Microsoft.WindowsAzure.Storage; Using Microsoft.WindowsAzure.Storage.Blob; using System.IO; public class ExampleUploadReportToBlobStorage {     public static void main(Args _args)     {  ...
Read more

Microsoft D365 F&O: Remove custom models from deployable package

Image
Sometime we deploy custom model to PROD/Sandbox and due to some reason needs to revert back custom model code. If we revert back code, code reverted back but model still exist in the  environment. the next time when we suppose to deploy new package, deployment would failed with following reason: "The selected package is missing the following modules that are currently deployed on your environment. You must create an all-in-one deployable package that contains all your code customizations and ISV solutions. More information can be found at the following link:  https://go.microsoft.com/fwlink/?linkid=2118104 . Missing module(s): [ Package1 ] ,[ Package2 ] [ Package3 ]’ (Activity Id: ‘12345XXXX’)" I will explain how to remove the custom models from your environment(PROD/Sandbox). Steps 1.  Create a deployable package from your VM(Visual studio) or download the build package 2.  Unzip the deployable package and open the deployable package folder. 3. Go to   \AX...
Read more

Generate Text/CSV/DAT file using X++ and upload on Azure blob storage

 Generate Text/CSV/DAT file using X++ and upload on Azure blob storage There are many scenario's where we want to wrap data inside the file and upload on blob storage. Following code use to generate file and upload on azure blob storage. `   public void processOperation(Contract _contract)     {         #OccRetryCount         #File         InventTrans          inventTrans;         Query                query;         QueryRun             queryRun;         str                  stringToWrite;         int                  recordCount = 0;         stringToWrite = "Customer Account Number|Invoice Amou...
Read more