May 6, 2004 at 3:43 pm
Can someone piont me to a document or explain when a user creates a table when they get ownership as opossed to dbo. I have users who are dbo of a database and when they create a table it gets user.table instead dbo.user. Other times i see users create tables and it creates dbo.user.
May 6, 2004 at 4:05 pm
These are the things I know from testing before.
1) If you make the user a standard user with access to the DB but give db_owner or db_ddladmin fixed role in the DB the objects will be created under their ownership unless they specify dbo.
2) If you make the user a standard user of the DB but use sp_changedbowner to make the the actual DBO of the db they will create objects owned by dbo regardless of fixed role in DB.
3) If you make them a SA of the server and give access to the DB they will create objects under dbo regardless of fixed role in DB.
In both cases 2 and 3 they can create objects owned by them by setting the owner name in the create like so owner.tablename
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply