Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2005-09-21 : 09:07:42
|
| HiI am confused with the permissions for the objects in my database.when a developer creates a new SP the permissions are given by default for that developer but in some databases I am giving it manually, where do i need to check for this. |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-21 : 09:37:08
|
| are you the dbo? rights to execute sp's are always granted to the creator. dbo has rights to execute all sps.====================================================Regards,Sean Roussyaka the merciless black hearted capitalist troublemaker"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
 |
|
|
supersql
Yak Posting Veteran
99 Posts |
Posted - 2005-09-21 : 10:04:08
|
| yeah I got it, for that I need to assign the user to fixed database role "dbowner". |
|
|
|
|
|
|
Permissions