dbo doent exist or no permission

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

dbo doent exist or no permission

Author

Topic

cottage125
Starting Member

32 Posts

Posted - 2008-06-04 : 13:20:33

In My environment a database role named db_execute(for execute permission) and its owner is dbo and its owned schema is db_execute.
We have few SPs.
db_execute role has permission to execute these SPs.
so members of that role can execute those SPs.
one of the (user)account is a member of this role
when I execute that SP in backend from this account it runs fine but
when developers call it from front end with same account they gets this error
Unexpected Database error -
ErrorNamespace: DB.SqlServer
ErrorNumber:2760
The specified schema name "dbo" either does not exist or you do not have permission to use it.
Whats should be the work around??Where n what should I check now?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-04 : 13:55:29

What schema does your SPs have?

cottage125
Starting Member

32 Posts

Posted - 2008-06-04 : 14:04:33

The role db_execute has grant permission to execute those SPs
My SPs are executing or calling some other SPs but all have this permission

cottage125
Starting Member

32 Posts

Posted - 2008-06-04 : 14:05:19

The schema is dbo for all SPs

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-04 : 14:06:45

What is owned schema for that user?

cottage125
Starting Member

32 Posts

Posted - 2008-06-04 : 14:12:58

That user is not owning any schema for that database
but that user is a member of db_execute role.
Do I need to make him a member of some schema?? which one

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-04 : 15:48:24

Make that user default schema dbo.

cottage125
Starting Member

32 Posts

Posted - 2008-06-04 : 15:54:24

the default schema for that user is already dbo.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-04 : 23:29:59

Tried call sp with schema like dbo.sp_name?