Home > Archive > MS SQL Server security > February 2006 > [SQL2000] permissions to use view based on tables from many databases









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author [SQL2000] permissions to use view based on tables from many databases
Grzegorz Danowski

2006-02-17, 7:23 am

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. In the
same database (Customers) I have created a stored procedure based on the
view. I'd like to give to some users permission to open the stored
procedure.

Have I to add all those users to Customers? If yes, please describe me how
to limit those users privileges to open only the stored procedure but no
tables or view from Customers.



Regards,

Grzegorz

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com