Administrating roles on several databases and cubes ?

Anyone know of somekind of tool, where you easy can administrate userroles on several databases and cubes ?

No. I would appreciate a product that could do that. Roles are related to solutions/databases not across solutions/databases.

When Active Directoryn was introduced in Windows 2000 my naive idea was that each application would build its security repository around AD. This is not the case nore for MS-products.

Regards

Thomas Ivarsson

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.