top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What security features are available for stored procedure?

+2 votes
335 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
...