Home All Groups Group Topic Archive Search About

SQL 2005 Role Permissions

Author
30 Jun 2006 5:51 PM
Sherri
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.

Author
2 Jul 2006 5:42 AM
Uri Dimant
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.
>

AddThis Social Bookmark Button