|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL 2005 Role PermissionsHow can permissions be set across schemas?
I have tables in one schema and views from those tables in another schema. Is this possible? If so can you point me to any articles describing how this can be done? The issue, I do not want users having access to tables only the views which reside in another schema. Thank you in advance for any assistance. Sherri
http://www.sommarskog.se/grantperm.html#ownershipchaining Show quote "Sherri" <sherri.garri***@dmh.mo.gov> wrote in message news:1151689903.080560.49680@i40g2000cwc.googlegroups.com... > How can permissions be set across schemas? > > I have tables in one schema and views from those tables in another > schema. > > Is this possible? If so can you point me to any articles describing > how this can be done? > > The issue, I do not want users having access to tables only the views > which reside in another schema. > > Thank you in advance for any assistance. > |
|||||||||||||||||||||||