Validating sql stored procedures

bathroom-blowjob

The first would be to just set default values within the procedure declaration to guarantee that there would never be NULL values passed in for these parameters: ALTER PROCEDURE [dbo].[sp_Example] @parameter1 char (8), @parameter2 char (20), @parameter3 char (20), @parameter4 char (20), @parameter5 char (20), @parameter6 char (20),...

bathroom-blowjob

You have an application with a Users table, and the Users table has various columns to indicate what rights a User has within the application.Ignoring for the purposes of this question what should be done in server-side app code to implement user rights authorization, I am wondering from a dba's perspective (and security perspective) whether it is a good idea or an anti-pattern to include validation of the user's rights inside of the stored procedure. It has a stored proc where the User ID is one of the parameters to the proc.

uefa-europa-league.ru

18 Comments

  1. Pingback:

  2. eric   •  

    more about Alexandra from Odessa What do men usually see first in a woman? You need to look at me attentively)) I know I am beautiful woman, but I will let you know my inner wor...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>