What security features are available for stored procedures?


Interview questions

SQL Server stored procedures


What security features are available for stored procedures?

What security features are available for stored procedures?

Database users can have permission to execute a stored procedure without being granted permissions to access the database objects on which the stored procedure operates.

Database users can be restricted from reading SQL command in the stored procedure by encrypting it.

Sql server - What security features are available for stored procedures? - Feb 11, 2010 at 11:55 AM by Shuchi Gauri

What security features are available for stored procedures?

Security features for stored procedures:

  • Grants users permissions to execute a stored procedure irrespective of the related tables.
  • 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.
  • Stored procedures can be granted execute permissions rather than setting permissions on data itself.
  • Provide more granular security control through stored procedures rather than complete control on underlying data in tables.

Also read

What are the advantages of using Stored Procedures?

Stored procedures provide performance benefits through local storage, precompiling the code, and caching................

What are the events recorded in a transaction log?

Answer - The start and end of each transaction......

Describe when checkpoints are created in a transaction log.

Answer - It is created when CHECKPOINT statement is executed.......  

Define Normalization and De- Normalization.

Answer - It is the process of organizing data into related table. To normalize database, we divide database into tables.....

Question: What is the significance of NULL value and why should we avoid permitting null values?

Answer - Null means no entry has been made. It implies that the value is either unknown or undefined.....

Write your comment - Share Knowledge and Experience

Latest placement tests
Latest links
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring