How to make secure sqlserver database and storedProcedures in it

Question

I have an application in c#.net with Sqlserver database.I want to secure database and stored procedures in it .Is there any way that stored procedures no to be open with any body who logged in to sql server to see certificate and master key in it or modify them. please help me

aziz · Accepted Answer · 2017-08-10 10:51:59Z

0

If I understood well your question , you can make role and assign each user to these role, and then grant kind of permission to the users such as Execute, following link can help you

Grant execute permission for a user on all stored procedures in database?

https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql/managing-permissions-with-stored-procedures-in-sql-server

answered Aug 10, 2017 at 10:51

aziz

932 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to make secure sqlserver database and storedProcedures in it

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related