VIEW DATABASE STATE permission
GPTKB entity
Statements (21)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
SQL Server permission
|
| gptkbp:appliesTo |
gptkb:SQL_Server_database
|
| gptkbp:canBe |
application role
database principal database role database user |
| gptkbp:canBeDeniedWith |
DENY statement
|
| gptkbp:canBeGrantedWith |
GRANT statement
|
| gptkbp:canBeRevokedWith |
REVOKE statement
|
| gptkbp:hasAbility |
see information about all sessions in the database
view metadata of all objects in the database |
| https://www.w3.org/2000/01/rdf-schema#label |
VIEW DATABASE STATE permission
|
| gptkbp:introducedIn |
gptkb:SQL_Server_2005
|
| gptkbp:requires |
monitoring database activity
querying dynamic management views (DMVs) viewing sys.dm_db_index_usage_stats viewing sys.dm_exec_requests viewing sys.dm_exec_sessions viewing sys.dm_tran_locks |
| gptkbp:bfsParent |
gptkb:Dynamic_Management_Views
|
| gptkbp:bfsLayer |
6
|