Server role and Database Role

[Sovanndy]

Can u explain me differenty between server role and database role?

[mendhak]

I'm not sure that's what he was asking.

In SQL Server, a server role is something like sysadmin, serveradmin, dbcreator, and others I cannot remember.

A database role would be something like dbo (db owner), public roles, or any roles you create yourself.

The difference is quite simple, server roles exist at the server level, so you can imagine them to be like administrators that can access any database in the server instance.

A database role is limited to the database to which it has been specified.

[szlamany]

We use database roles to simply permission assignments in SQL Server.

We create a DATABASE ROLE - give that role the specific objects and types of permissions needed.

Then the system admins assign these roles to WINDOWS USERS. Actually the smarter admins assign the roles to WINDOWS GROUPS - further simplifying what can become a very intensive procedure. Obviously as users are added to the AD they are associated with the proper WINDOWS GROUPS...