What happens when a Data Provider revokes privileges to a share on an object in their source database?
What happens when a Data Provider revokes privileges to a share on an object in their source database?
When a Data Provider revokes privileges to a share on an object in their source database, the object immediately becomes unavailable for all Data Consumers. This action effectively removes the objects from the share, thus disabling access for any Data Consumers that previously had access through the share.
Answer correct Revokes access privileges for databases and other supported database objects (schemas, tables, and views) from a share. Revoking privileges on these objects effectively removes the objects from the share, disabling access to the objects granted via the database role in all consumer accounts that have created a database from the share.
Correct answer
A is correct
correct