Sql Security

vadivelanvaidyanathan · #1 (**permalink**) 08-08-2007, 12:43 AM

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??

Murali · #2 (**permalink**) 08-09-2007, 08:51 AM

Hi,

Why dont you try to give Execute permission for that stored procedure for your own user.

Try this,

Code:

GRANT EXECUTE ON DBO.<Objectname> TO <User>
GO

Remember onething if any other dependencies for that procedure or tables also has to be given privilege.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Security in PHP	rekhaa	PHP Programming	153	09-24-2008 07:56 AM
PHP security	jegan	PHP Programming	1	08-29-2007 04:52 AM
Security for ASP.net	nhoj	ASP and ASP.NET Programming	0	04-09-2007 09:19 AM
VB.net Security	nhoj	VB.NET Programming	1	04-06-2007 01:50 AM
eBay Security	nhoj	eCommerce	0	04-03-2007 12:00 PM