:::: MENU ::::

Trustworthy (TRUSTWORTHY) in SQL Server 2005

  • Nov 05 / 2008
  • 0
dbDigger, Security and Permissions, T-SQL Enhancements

Trustworthy (TRUSTWORTHY) in SQL Server 2005

Trustworthy option is used to control access to resources outside the database. When trustworthy is set to TRUE in SQL Server Management Studio or ON when using the ALTER DATABASE command, database modules like user-defined functions and stored procedures that use an impersonation context can access resources outside the database. When Trustworthy is set to FALSE, database modules that use an impersonation context cannot access resources outside the database.
Consult us to explore the Databases. Contact us