top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

What security features are available for stored procedure?

+2 votes

What security features are available for stored procedure?

posted Aug 22, 2014 by Khusboo

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+2 votes
Best answer

1.Grants users permissions to execute a stored procedure irrespective of the related tables.
3.Grant users users permission to work with a stored procedure to access a restricted set of data yet no give them permissions to update or select underlying data.
3.Stored procedures can be granted execute permissions rather than setting permissions on data itself.
4.Provide more granular security control through stored procedures rather than complete control on underlying data in tables.

answer Nov 13, 2014 by Manikandan J
Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.