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 helpYou 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...
Or...
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.
What'dya think?sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment