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
102 views

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
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...