Grant EXECUTE to user for stored procedures in a schema.

- 
GRANT EXECUTE ON schema::<schema name> TO <user name>


GRANT EXECUTE ON Sp_DateWiseItemSalesReport TO storemanager

Comments

Post a Comment

Popular posts from this blog

C# - Strong Password Regular Expression

-
^(?=.*[A-Z])(?=.*[a-z])(?=.*[0-9])(?=.*[~!@ #$%^&*_+=[{\]};:<>|.?,-]).{6,20}$ var hasMatchPasswordRegex = new Regex(service.GetGlobalSetUp().Rows[ 0 ][ "password_regex" ].ToString());             if (!hasMatchPasswordRegex.IsMatch(change_password.NEW_PASSWORD))             {                 response.status = HttpStatusCode.InternalServerError;                 response.statusText = " <strong>Fail</strong>" + service.GetGlobalSetUp().Rows[ 0 ][ "password_mis_match_message" ].ToString();                 var resultOutput = JsonConvert.SerializeObject(response, Formatting.Indented,                       new JsonSerializerSettings                       {   ...
Read more

Provision AWS EC2 Instance and RDS with Terraform, and Deploy Spring Boot App to EC2 Instance via GitHub Action Pipeline

-
Image
  These days, Terraform is a popular tool for managing infrastructure as code. Manually creating AWS EC2 instances and deploying Spring Boot applications to them can be challenging. In this tutorial, I will demonstrate how to use Terraform to provision an AWS EC2 instance and an AWS RDS MySQL database, and then deploy a Spring Boot project to that EC2 instance using a GitHub Action pipeline. Prerequisites: To follow this tutorial, you need to have the following prerequisites: An AWS account Terraform installed on your local machine. GitHub Account A Spring Boot Project Putty What We will do : Create AWS EC2 & RDS(MYSQL) Instance using Terraform Deploy Spring Boot Project in that EC2 Instance Using GitHub Action Create AWS EC2 & RDS(MYSQL) Instance using Terraform: Step 1: Create and Configure an AWS Free Tier Account AWS offers a free tier account with a 12-month free offer that allows you to use most of its resources for educational purposes. To get started on AWS, you fi...
Read more

Microsoft Access Connectivity from C#

-
<configuration>   <appSettings>     <add key="ConnectionString" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=BCI.accdb;" />     <add key="ClientSettingsProvider.ServiceUri" value="" />   </appSettings> </configuration> http://aksadur.blogspot.com/2013/01/microsoft-access-connectivity-from-c.html
Read more