Class InformationSchema.ColumnPrivilege
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
COLUMN_PRIVILEGES (Transact-SQL)
Applies to: √ SQL Server (all supported versions) √ Azure SQL Database
Returns one row for each column that has a privilege that is either granted to or granted by the current user in the current database.
To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA._view_name_.
[Table(Schema = "INFORMATION_SCHEMA", Name = "COLUMN_PRIVILEGES", IsView = true)]
public class InformationSchema.ColumnPrivilege- Inheritance
-
InformationSchema.ColumnPrivilege
- Extension Methods
Properties
ColumnName
Column name.
[Column("COLUMN_NAME")]
[Nullable]
public string? ColumnName { get; set; }Property Value
Grantee
Privilege grantee.
[Column("GRANTEE")]
[Nullable]
public string? Grantee { get; set; }Property Value
Grantor
Privilege grantor.
[Column("GRANTOR")]
[Nullable]
public string? Grantor { get; set; }Property Value
IsGrantable
Specifies whether the grantee can grant permissions to others.
[Column("IS_GRANTABLE")]
[Nullable]
public string? IsGrantable { get; set; }Property Value
PrivilegeType
Type of privilege.
[Column("PRIVILEGE_TYPE")]
[Nullable]
public string? PrivilegeType { get; set; }Property Value
TableCatalog
Table qualifier.
[Column("TABLE_CATALOG")]
[Nullable]
public string? TableCatalog { get; set; }Property Value
TableName
Table name.
[Column("TABLE_NAME")]
[NotNull]
public string TableName { get; set; }Property Value
TableSchema
Name of schema that contains the table.
Important Do not use INFORMATION_SCHEMA views to determine the schema of an object. INFORMATION_SCHEMA views only represent a subset of the metadata of an object. The only reliable way to find the schema of a object is to query the sys.objects catalog view.
[Column("TABLE_SCHEMA")]
[Nullable]
public string? TableSchema { get; set; }