If you want that user to be able to grant that access to other users. For example, you have a group of BI analysts who will be managing a set of tables/objects (they create new tables, views, procedures, etc...) - and they want to give a different group read access to their objects.
1 Like