SQL SECURITY

[Guest_imported]

I am learning/running/developing an SQL 2000 Server. I have one employee who is writing the stored procedures and creating all of the tables, ect. He currently has permissions to datareader and datawriter. Our issue is that every time he creates a new stored procedure, he maintains ownership under his account "NAME/Domain Name"(before setting up his system we added 50+ stored procedures under the dbo account). When trying to execute these from any of the other machines in our workplace we get an error message stating that the stored procedure cannot be found. If we then go and manually change the ownership back to the dbo account the SP runs fine. I would like to know either how to stop his account from taking ownership, or to know how to allow our users to execute the stored procedures from both owners. Any suggestions??

 

[schrikanth]

granting permissions on the stored procedure to the user is the answer.....ref. GRANT in SQL Server Online Books for syntax