Showing posts with label owner. Show all posts
Showing posts with label owner. Show all posts

Thursday, February 16, 2012

Allow user to Kill Sesions

I have a user who is Business owner of a database that is transactional.

At times some of here staff will be the leadblocker.

She has requested that she be allowed the abiity to KILL spids that are blocking her remaining users. All have blessed this process and I havve been tasked to create a way for this to be accomplished.

Is this as simple as allowing this user a permission or is it more in depth.Only a system administrator can kill processes.

My suggestion would be to create a login specifically for this purpose (kills by a business owner), and write a small application that actually uses that login to do the kill.

You have a minor problem working out how to authenticate the user, but I wouldn't think that would be too complicated, especially if you use Windows Authentication.

-PatP|||My suggestion would be to find out why the processess are being blocked and actually fix the problem...but that's just me.|||I have to agree with Pat and Blindman here on the right way to approach this. You may end up with this user killing backup jobs, data updates, and other stuff that can be a real pain to both troubleshoot, and fix.

That said, you can accomplish this by adding the user to the processadmin server role. Good luck.|||Thank you all for your suggestions.

I will try to implement. I would attempt to fix the problem however I am just keeping the lights on, on this server. No longer in my sphere of control.|||Thank you all for your suggestions.

I will try to implement. I would attempt to fix the problem however I am just keeping the lights on, on this server. No longer in my sphere of control.Pehaps, given the requirements of this task, that is for the best from your point of view ;)

Allow Developer to Design tables, but not be owner?

I have some developers that I need to be able to do anything to the Database
except look in a few tables in that database.
I have a DenyHR Role that denies Access to the HR Tables, though if I give
them dbOwner that seems to defeat the purpose.
They need to still create and design existing tables. How can I accomplish
this?
Thank you,
Scott<-It sounds like you need to put them in the db_ddladmin role.
Alter table isn't transferable so you'd likely need to use
this role which is more restrictive than db_owner.
-Sue
On Thu, 7 Sep 2006 11:45:57 -0700, "Scott Townsend"
<scooter@.nospam.postalias> wrote:

>I have some developers that I need to be able to do anything to the Databas
e
>except look in a few tables in that database.
>I have a DenyHR Role that denies Access to the HR Tables, though if I give
>them dbOwner that seems to defeat the purpose.
>They need to still create and design existing tables. How can I accomplish
>this?
>Thank you,
> Scott<-
>|||Using SQL 2000, there is no easy solution at hand. In some situations, the
'sensitive' data tables are put into a different database for reasons like
this one. Different security needs.
Using SQL 2005, you may benefit from investigations schemas. See 'Using
Schemas' in Books Online.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Scott Townsend" <scooter@.nospam.postalias> wrote in message
news:Ojh7b3q0GHA.4772@.TK2MSFTNGP03.phx.gbl...
>I have some developers that I need to be able to do anything to the
>Database except look in a few tables in that database.
> I have a DenyHR Role that denies Access to the HR Tables, though if I give
> them dbOwner that seems to defeat the purpose.
> They need to still create and design existing tables. How can I accomplish
> this?
> Thank you,
> Scott<-
>