Question 690
A new authorized partner account must be included in the share's recipient set. What alteration fits?
Explanation
Correct Answer
Correct: adding consumer accounts. ALTER SHARE ... ADD ACCOUNTS authorizes designated consumer accounts to access the configured share.
Incorrect Answers
Not correct for the collaboration need: CREATE SHARE creates a named direct-share object to configure; this scenario calls for adding consumer accounts.
Not correct for the collaboration need: GRANT USAGE ON DATABASE ... TO SHARE allows a share to reference the provider database; this scenario calls for adding consumer accounts.
Not correct for the collaboration need: GRANT SELECT ON TABLE ... TO SHARE grants approved table read access through a share; this scenario calls for adding consumer accounts.