var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: db_owner role and table owner issues
I have given a user db_owner role in a database. When he creates a table using Enterprise manager the table owner is dbo. When he creates a table using Query Analyzer the table owner is the user. eg
Enterprise Manager = dbo.Table1
Query Analyer = username.Table1
This causes a problem when the user is writing web applications. Is this an error in the way i have set up permissions ? How can i make them behave the same way?
Thanks for your help.
First, don't create tables in EM
Second, it's how they are connecting...
Third, depending on how you want the application to work, qualify the owner...
Fourth, get control...
have them supply you with the DDL, and you create the tables for them...
My guess is that EM is connected with sa, and QA is connecting with their id...
just a guess...
Thanks for your quick response. I should have included the following information.
I work in a University computing department where students must learn to create tables etc. I could not create their tables for them as it is part of their assessment (and there are 1700 students!)
Students can only log on to the server using windows authentication so will log on using the same windows account to both EM and QA.
Students are taught to use both EM and QA which is why they are finding problems.
Thanks again for all help.
Gotta test it...which way do you want the tables qualified for their apps...
I'll look into it...