user can perform any operation on n number of databases except delete atleast one database.

See more:

SQL-Server

SQL-Server-2008R2

, +

hi friends,

i have 200 databases, my senior asking me to a user is asking me to do any type of operation on all 200 databases but he dont have permission to delete atleast one database but he can delete tables,objects,sp..but he dont delete database(atleast one in 200 databases)

can you please give me the solution with a role(database role or server role)

thanks,
Ramakrishna