how can we maintain security in soted procedure?

Answer Posted / rakesh patil

We can make use of 'with Encryption' option in our stored procedure declaration,
it will definitely provide the security of your stored procedure.

You nee to include above mention option after "as"

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is break mode?

713


Explain exception handling in .net.

834


What is full trust in asp.net?

744


Explain Areas in MVC?

829


I am trying to implement sorting facility from client side code in GridView Control. So how can I fill up an Array inside client side code (using JavaScript), i want to assign my DataSet object declared and filled up on Server side(in code behind) to the array (on client side)

1737


How to implement Authentication and Authorization?

766


Is there any property names “isnavigating”?

738


Explain how cookies work. Give an example of cookie abuse.

884


If we remove web.config or machine.config from the application then, is this application will works?

786


What are the different types of events are occured when a client requests an ASP.NET page from IIS server?

820


Explain the various authentication mechanisms in asp.net.

708


Explain how is a property designated as read-only?

763


What is use of Master Page in ASP.NET web pages?

812


What is a form tag?

699


What is ViewState? What does the "EnableViewState" property do? Why would I want it on or off?

888