March 18, 2004 at 12:22 pm
I set up a login alias to a user account that owns objects in a database. I did this so that a developer could select from tables without prefixing with the object owner and in addition have the extra permissions they need in Enterprise Manager. The user account has no extra permissions or roles. The developer has an alias to the user account as well as the sysadmin fixed server role. This was working but now he has to prefix the objects with the owner. I can't figure out what could have changed
March 22, 2004 at 8:00 am
This was removed by the editor as SPAM
April 2, 2004 at 11:30 am
When a user has given a sysadmin role then what ever he creates either a table,stored procedure etc, SQL Server automatically assigns dbo as the owner of the table.
A user need not access the table as dbo.<table name> , he can use <table name> without dbo .
If a user who doesn't have sysadmin role creates the object . for example sam creates a customer table then the owner becomes sam and the table needs to be accessed as sam.customer
So its a good practice to make owner of the object as DBO and if a user wants to take full responsibility of that object then you can assign him a fixed database roles like db_owner.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply