Permission Question

[DirectOne]

I have a sp that uses a linked server (pervasive) and sql database, it will run logged in as SA or builtin\admin accounts, I cannot however figure how to give users permissions to run the stored procedure.

domain users can access the sql database.

How do I give users right similiar to these accounts, I have already tried making the system admins.

Thanks,

 

[mrdenny]

You grant exec rights to the stored proc via the grant command.

grant exec on StoredProc to UserName

On the linked server you will need setup either setup each user specifically and map them to a SQL user on the remote server or setup a default security context (at the bottom) of the page. Both are setup o the security page (the middle one).

You can not map groups in the linked server setup, you have to do it user by user, or via the default mapping.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[DirectOne]

I have set exec permission on the sp, the linked server has no security on it, Perasive 2000i using odbc.

I have tried mapping users throught he linked server security tab, but I don't understand because the pervasive database has no security on it.

I gave the sp exec right through em, does it need to be done in query analyzer?