-
Owner of stored procedures (reply)
You should change the owner of all user defined stored proc to dbo. It will save you a lot of headache in the future.
HLT
------------
MAK at 3/2/01 10:24:52 AM
create a common login/user for these.
use "Sp_changedobjectowner" to change the ownership.
------------
Quyen Hang at 3/2/01 10:02:52 AM
We have three programers developping an application with Visual Basic. They have created some stored procedures, each stored procedure is owned by the its creator. So when M. A want to use the stored procedure created by M. B, he has to put B.stored procedure name and so on. It is really not pratical.
Now, we are looking for a method to make the owner of those stored procedures unique and the programers can modify a stored procdure at any time. Do you have any suggestions ? Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|