Reply to Re: [SQL2000] permissions to use view based on tables from many databases

Your name:

Reply:


Posted by Grzegorz Danowski on 10/01/22 11:40

Thanks, it works.
Grzegorz

Użytkownik "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> napisał w
wiadomości news:O07NN2uNGHA.2064@TK2MSFTNGP09.phx.gbl...
> Are the objects owned by the same owner in both db's? If so you may have
> to specify rights on the other tables. Is Cross database Ownership
> chaining turned on?
>
> http://support.microsoft.com/?kbid=810474
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Grzegorz Danowski" <gdn__na@serwerze__poczta.onet.pl> wrote in message
> news:dtf589$5h3$1@inews.gazeta.pl...
>> Well, it works fine in situations when all tables are in the same
>> database, but it doesn't work when tables are in two databases. If user
>> have no rights to read source table from other database SQL Server shows
>> error:
>> "SELECT permission denied on object 'CustomersData', database
>> 'Customers', owner 'dbo'."
>>
>> Grzegorz
>>
>>
>> Użytkownik "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> napisał w
>> wiadomości news:%23Iia6cuNGHA.2336@TK2MSFTNGP12.phx.gbl...
>>> By default when you add a user they do not have any permissions to do
>>> anything. So just make sure you don't add them to any of the server or
>>> database roles. Then simply GRANT them execute permission on that sp.
>>>
>>> --
>>> Andrew J. Kelly SQL MVP
>>
>
>

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация