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

[Back to original message]