1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What security features are available for stored procedure?

Question Posted / nikhilesh kumar


What security features are available for stored procedure?..

Answer / Chetan Warkari

SQL Server provides several security features for stored procedures, such as role-based access control (RBAC), database principal authentication, dynamic SQL authorization, and encryption using Transact-SQL functions like ENCRYPTBYPASSPHRASE or ENCRYPTBYKEY.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is 3nf normalization form?

1 Answers  

What is merge replication?

1 Answers  

What is difference between stored procedure and function?

3 Answers   L&T,

HOW TO RENAME A COLUMN NAME

3 Answers  

What is the need for indexing?

1 Answers  

Why union all is faster than union?

1 Answers  

What is a select query statement in ms sql server?

1 Answers  

How to disable triggers using "disable trigger"?

1 Answers  

How to concatenate two binary strings together?

1 Answers  

Explain the steps to use transact-sql cursor?

1 Answers  

What is a self join in sql server?

1 Answers  

What is attribute relationships, why we need it? : sql server analysis services, ssas

1 Answers  

For more SQL Server Interview Questions Click Here
Categories