Possible to add db role to server role ?

[kim1]

Hi everyone,

Is it possible to add a Database Role to a Server Role?

Kim

Kim

 

[JamesLean]

No - that doesn't really make sense. Can you explain what you are trying to achieve?

--James

 

[kim1]

Hi James,

I have a database roll that has some users in it and sometimes I need those users to have sysadmin priviledge.

Is there anyway to set so I don't have to set manually each sql login to have sysadmin?

Thank you for your help.

Kim

Kim

 

[cehepker]

Hello,

I have never had occasion to do this, but I went in an added an application role to the server role just fine. So it seems like it is possible.

Carla

Documentation: A Shaft of light into a Coded world

 

[kim1]

Carla,

I think you can add an application role but not a database role to a Server Role because the application role is at the server level (if I am not wrong.)

Kim


Kim

 

[cehepker]

Kim,

Good point, I was not looking at the actual "server" roles. Sorry.

Carla

Documentation: A Shaft of light into a Coded world