0

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

Ehsan Sajjad
  • 59,154
  • 14
  • 90
  • 146
ssss
  • 19
  • 1
  • 6

1 Answers1

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://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/managing-permissions-with-stored-procedures-in-sql-server

aziz
  • 101
  • 2
  • 8