nfung
December 26th, 2003, 02:44 AM
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.
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.