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# DataTable to List Convert

-
public static List DataTableToList (this DataTable table) where T : class, new() { try { List list = new List (); foreach (var row in table.AsEnumerable()) { T obj = new T(); foreach (var prop in obj.GetType().GetProperties()) { try { PropertyInfo propertyInfo = obj.GetType().GetProperty(prop.Name); propertyInfo.SetValue(obj, Convert.ChangeType(row[prop.Name], propertyInfo.PropertyType), null); } catch { continue; } } list.Add(obj); } return list; } catch { return null; } } Re...
Read more

EncryptDecrypt Web config c#

-
  public static void WebEncryptDecrypt()         {             Configuration config = ConfigurationManager.OpenExeConfiguration(Application.ExecutablePath);             ConfigurationSection configSection = config.GetSection("appSettings");             ConnectionStringsSection ConSection = config.GetSection("connectionStrings") as ConnectionStringsSection;             if (configSection.SectionInformation.IsProtected)             {                 configSection.SectionInformation.UnprotectSection();                 ConSection.SectionInformation.UnprotectSection();                 config.Save();                           ...
Read more