November 17, 2011 at 4:56 pm
I have created a copy of a database for a user to play with and made the user a db_owner. When the user tries to create a sproc, he gets an error saying the Schema User.Name does not exist or he does not have the correct permissions. I can not see what could be configured wrong. I'm running SQL Server 2008. Any ideas? Thanks
November 17, 2011 at 5:50 pm
is the user logging in using the same account you granted to dbo?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 17, 2011 at 5:51 pm
also, when executing have the user exec the proc using the dbo schema name
e.g.
exec dbo.proc
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 17, 2011 at 6:00 pm
It's not the execution of the sproc that is causing the error, its during the creation. I'm using MS Access as a front end and simply creating a select stored procedure from a single table. The schema it says does not exist is the users log in name. There is no such schema and since the user is a dbo I don't know why it is giving the error.
November 17, 2011 at 6:07 pm
Try this
Create proc dbo.someproc
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 18, 2011 at 1:08 am
Also check what is the default schema for the user and if it exists.
[font="Verdana"]Markus Bohse[/font]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply