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
>>
>
>

• Next in forum: Re: Formula problem
• Prev in forum: Re: [SQL2000] permissions to use view based on tables from many databases
• Thread view: Re: [SQL2000] permissions to use view based on tables from many databases

[Reply to this message]