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 |
|
poser
Posting Yak Master
124 Posts |
 Posted - 2008-07-15 : 18:50:15
|
| I am in .net and trying and connecting to my database as a user with dbo permissions.When .net tries to create a new stored procedure it tells me user does not have permissionsto the schema. In the query window within sql I have no problem so it does not seem to be a permissions issue.Thanks for any and all help.R/Poser |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-15 : 22:53:23
|
| Did you specify schema when create sp in .net app like schema.sp_name? |
 |
|
|
poser
Posting Yak Master
124 Posts |
Posted - 2008-07-16 : 15:57:53
|
| So schema name is the database name?User is testuser and is in the dbo group.Then if my database name is testCreate procedure dbo.test.sp?Does my user have to be added under schema?I am new to this and really appreaciate any help.Thanks, P |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-16 : 16:00:50
|
| Does your .net user have dbo permissions? You can only create dbo objects if you are a member of the db_owner database role.It shouldn't be dbo.test.sp but rather dbo.sp.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
Error no permissions to schema?