I need to create user with less permissions with out sys_admin role. When i tried to login to my app changing this user and pwd created with out sys-admin role in connection string. It says it cannot execute some sp in master database" user needs to be added to sys_admin role" tried granting execute permission to that stored procedure for the user i have created still fails saying user needs to be added to sysadmin role.
Please suggest any solutions.
Thanks in advance.