Thursday, February 9, 2012

admin or other role

I have one other question. How do you define roles? What role(s) are required to fully administer SQL Server? What role(s) are required to fully administer a single database in SQL Server?

thanks,

In Books Online, look up [fixed server roles] and [fixed database roles].

Those roles are predefined. You can also create your own roles (which only has permissions that you grant to them.)

Full server administration = sysadmin.

Single database administration = db_owner.

No comments:

Post a Comment