IS_OBJECTSIGNED (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Indicates whether an object is signed by a specified certificate or asymmetric key.
Transact-SQL syntax conventions
Syntax
IS_OBJECTSIGNED (
'OBJECT', @object_id, @class, @thumbprint
)
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Arguments
'OBJECT'
The type of securable class.
@object_id
The object_id of the object being tested. @object_id is type int.
@class
The class of the object:
'certificate'
'asymmetric key'
@class is sysname.
@thumbprint
The SHA thumbprint of the object. @thumbprint is type varbinary(32).
Returned Types
int
Remarks
IS_OBJECTSIGNED returns the following values.
Return value | Description |
---|---|
NULL | The object is not signed, or the object is not valid. |
0 | The object is signed, but the signature is not valid. |
1 | The object is signed. |
Permissions
Requires VIEW DEFINITION on the certificate or asymmetric key.
Examples
A. Displaying extended properties on a database
The following example tests if the spt_fallback_db table in the master database is signed by the schema signing certificate.
USE master;
-- Declare a variable to hold a thumbprint and an object name
DECLARE @thumbprint varbinary(20), @objectname sysname;
-- Populate the thumbprint variable with the thumbprint of
-- the master database schema signing certificate
SELECT @thumbprint = thumbprint
FROM sys.certificates
WHERE name LIKE '%SchemaSigningCertificate%';
-- Populate the object name variable with a table name in master
SELECT @objectname = 'spt_fallback_db';
-- Query to see if the table is signed by the thumbprint
SELECT @objectname AS [object name],
IS_OBJECTSIGNED(
'OBJECT', OBJECT_ID(@objectname), 'certificate', @thumbprint
) AS [Is the object signed?] ;
See Also
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें