Follow the guidelines for the topics below found in this article.
Visibility of Subcomponent Metadata
The visibility of subcomponents, such as indexes, check constraints, and triggers is determined by permissions on the parent. These subcomponents do not have grantable permissions. For example, if a user has been granted some permission on a table, the user can view the metadata for the tables, columns, indexes, check constraints, triggers, and other such subcomponents.
Metadata That Is Accessible to All Database Users
Some metadata must be accessible to all users in a specific database. For example, filegroups do not have conferrable permissions; therefore, a user cannot be granted permission to view the metadata of a filegroup. However, any user that can create a table must be able to access filegroup metadata to use the ON filegroup or TEXTIMAGE_ON filegroup clauses of the CREATE TABLE statement.
The metadata that is returned by the DB_ID() and DB_NAME() functions is visible to all users.
The following table lists the catalog views that are visible to the public role.
| |||||||||||||||||
