DBO role in SQL Server 2005 versus DBA role?
Solution 1
A dba is not a system role, it's the title of the person who administers your database server (Data Base Administrator). There is no builtin role called "dba" in SQL.
High-level: DBO is the owner of the specific database and as such has the permissions to do anything within that datbase.
Solution 2
As squillman says, DBA isn't the name of a role. When you say DBA, I think you're meaning what's commonly called 'sa', or the 'sysadmin' server-level role.
DBOs (actually the 'db_owner' role) owns a database and has all permissions in the context of that database. For a list and description of all the database-level roles, see the Books Online topic Database-Level Roles.
Members of the sysadmin server-level role can do anything at all on the server, with no restrictions in scope or context. For a list and description of all the server-level roles, see the Books Online topic Server-Level Roles.
Hope this helps!
Related videos on Youtube
04 : 40
11 : 46
31 : 03
01 : 54
14 : 38
Paul Randal
I'm a consultant/trainer/author, SQL MVP, and I co-own and run SQLskills.com with my lovely wife and co-MVP Kimberly Tripp. I also blog and tweet a lot. Phew! I was on the SQL team for almost 9 nine years - wrote a bunch of DBCC commands (e.g. INDEXDEFRAG, SHOWCONTIG, CHECKDB/repair), ran the Access Methods development team for SQL Server 2005, and ended up being responsible for the entire Core Storage Engine for SQL 2008. Occasionally I have to resort to "I'm sorry, you are incorrect, the code does not do that", which I hate, as in https://imgur.com/gallery/8t74s. I'm an expert on Storage Engine internals, wait statistics, HA, maintenance, and disaster recovery. I teach this stuff internally for Microsoft and at conferences/clients around the world. The answer usually starts with 'it depends'! :-)
Updated on September 17, 2022Comments
-
Paul Randal over 1 year
What is the difference between DBO role versus the DBA role?
-
Admin almost 15 yearsThank you so much! A quick follow on Q: so does that mean DBAs typically give themsevles DBO rights or Sys Admin rights? Which takes precedence over the other I guess... -
squillman almost 15 yearsDBA's are typically the system administrators so it would follow that they are the ones that have sysadmin rights. The sysadmin trumps all, gives full permission server-wide. DBO only gives full permission at the database level. Thus it won't give you the permission to do things like create and drop databases, set up server logins, etc.
