var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Create SP denied ??
We added a user to a database with db_datareader, db_datawriter and Create Procedure Privilages .. while creating stored procedures using dbo. prefix he gets an error
Server: Msg 2760, Level 16, State 1, Procedure test4, Line 3
Specified owner name 'dbo' either does not exist or you do not have permission to use it.
What is the problem. We don't want him to create procedures with his uid as prefix .. Please help
You need to put him/her in the dbo_owner role...
Is it necessary ? If he is dbo he doesn't need to specify dbo. while creating objects . I don't want him to be a dbo
If yo uwant him to vcreate objetcs as dbo (the owner) he has to have the rights to be in the group...
He can develop in his own db you set up for him/her...make the dbo in that group (or not) and let them create objects without hard coding the owner...
Then have him give you the scripts and you compile them.