I need to grant select and update permissions to a DB user (TestUser) on TestDB database as per below.
When I press ok and re-check the permissions, they are not visible as can be shown below:
From my testing, only permissions at object level (e.g. columns, etc) are displayed here.
Can select permission on the database be visible from somewhere apart by executing T-SQL code? Is this a bug or by design? The same applies to user defined DB role permissions and it is very misleading.