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

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: [SQL2000] permissions to use view based on tables from many databases
• Prev in forum: Re: DTS Rounding problem
• Thread view: Re: [SQL2000] permissions to use view based on tables from many databases

[Reply to this message]