Class InformationSchema.TablePrivilege

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

TABLE_PRIVILEGES (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database

Returns one row for each table privilege that is 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_.

See INFORMATION_SCHEMA.TABLE_PRIVILEGES.

[Table(Schema = "INFORMATION_SCHEMA", Name = "TABLE_PRIVILEGES", IsView = true)]
public class InformationSchema.TablePrivilege

Inheritance

object

InformationSchema.TablePrivilege

Extension Methods

Map.DeepCopy<T>(T)

Properties

Grantee

Privilege grantee.

[Column("GRANTEE")]
[Nullable]
public string? Grantee { get; set; }

Property Value

string

Grantor

Privilege grantor.

[Column("GRANTOR")]
[Nullable]
public string? Grantor { get; set; }

Property Value

string

IsGrantable

Specifies whether the grantee can grant permissions to others.

[Column("IS_GRANTABLE")]
[Nullable]
public string? IsGrantable { get; set; }

Property Value

string

PrivilegeType

Type of privilege.

[Column("PRIVILEGE_TYPE")]
[Nullable]
public string? PrivilegeType { get; set; }

Property Value

string

TableCatalog

Table qualifier.

[Column("TABLE_CATALOG")]
[Nullable]
public string? TableCatalog { get; set; }

Property Value

string

TableName

Table name.

[Column("TABLE_NAME")]
[NotNull]
public string TableName { get; set; }

Property Value

string

TableSchema

Name of schema that contains the table.

Important 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; }

Property Value

string