use master
CREATE LOGIN <user>
use Database
CREATE USER <user>
The EXECUTE permission was denied on the object ‘myhistory’, database ‘BMTDWHGLDB’, schema ‘get’.
ALTER ROLE [exec_get] ADD MEMBER <user>;
ALTER ROLE [read_hvw] ADD MEMBER <user>;
DataSource.Error: Microsoft SQL: Error!! Error Number: 15151, Stored Procedure get_myHistory, Table Name: [hvw].[employee_details], Returned the following error : Cannot find the CREDENTIAL ‘https://bmtdwhuksstrprd.dfs.core.windows.net/gold/snapshot/employee/details/*.parquet’, because it does not exist or you do not have permission
use Database
GRANT CONTROL ON DATABASE SCOPED CREDENTIAL :: [datahistory_get] to <user>;
GRANT ADMINISTER DATABASE BULK OPERATIONS TO <user>;