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

Hi

I have two databases: Customers and Operations. In Customers database I have
made a view based on a few tables from both Customers and Operations (left
join - customers without any operations). In the same database (Customers) I
have created a stored procedure based on the view. Finally I'd like to give
to some users permission only to exec the stored procedure.

Have I to add the users to Customers? If yes, please describe me how to
limit the users privileges only to execution the stored procedure (no rights
to open tables or view from Customers).

Regards,
Grzegorz

Ps. I had sent the post on microsoft.public.sqlserver.security, but I had no
answer.

• Next in forum: Re: Connecting to SQL server
• Prev in forum: How to tell how many times an SQL executed in v7 or v2000?
• Thread view: [SQL2000] permissions to use view based on tables from many databases

[Reply to this message]