SQL server - Permission and ownership
Database
1
Posts
1
Posters
0
Views
1
Watching
-
1. I've created a a view based on table "Orders". 2. I've been assigned role="dlladmin", let's say my login="Tom" 3. I granted jane (public) access privilege by: grant select on vwOrders to jane 4. server admin "sa" transfered the view to dbo sp_changeobjectowner 'Tom.vwOrders', 'dbo' 5. I checked Jane's access privilege to vwOrders by: 5a. From Jane's account: select * from vwOrders result: NO problem, jane can access the view. OKAY. 5b. Enterprise Manager: Choose the table, select properties>Permission result: Jane was not assigned SELECT permission?? MY QUESTION: WHY? Is it a bug in Enterprise Manager? That privileges assigned before the view was transfered is not reflected in choose table>Properties>Permission? Thanks in advance.