mcrmg
asked on
SQL user
Hi,
I need to setup a SQL user for frontend to connect. What database role I should check?
It needs to be able to execute sp, insert new record, update/delete records.
I have checked db_datareader and db_datawriter and public
thx
I need to setup a SQL user for frontend to connect. What database role I should check?
It needs to be able to execute sp, insert new record, update/delete records.
I have checked db_datareader and db_datawriter and public
thx
Aneesh
that seems to be fine
ASKER
I am getting this error
The EXECUTE permission was denied on the object 'st_aaa', database 'my_DB', schema 'dbo'.
thx
The EXECUTE permission was denied on the object 'st_aaa', database 'my_DB', schema 'dbo'.
thx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can run:
GRANT EXECUTE TO login ;
GRANT EXECUTE TO login ;
ASKER
DO I have to do this to every sp? thx
If you do a login, you don't need to do to each proc.
Sorry my English...
If you do execute for all logins, you don't need to do for each proc, cause all procs already grant to public.
If you do execute for all logins, you don't need to do for each proc, cause all procs already grant to public.
ASKER
where can I set it? thx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I see, there is no way to do this via GUI? thx
yes...
You click with right button on database and choose properties. After this, you click on Permissions... click on user name on "user or roles box" and checkbox a grant to execute item.
database-properties.png
You click with right button on database and choose properties. After this, you click on Permissions... click on user name on "user or roles box" and checkbox a grant to execute item.
database-properties.png
ASKER
thanks again..