Re: changing role owner

From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 10/08/02 

From: "Andrew J. Kelly" <akelly@targitinteractive.com>
Date: Tue, 8 Oct 2002 08:45:19 -0400

Kimberly,

I pretty much came to the same conclusion as you but thought I must have
been missing something?? I don't get the purpose of role owners either and
could not find a way to change them. 

--
Andrew J. Kelly   SQL MVP
Targitinteractive, Inc.
Check out the PASS Community Summit - Seattle, the largest and only user
event entirely dedicated to SQL Server, November 19-22.
http://www.sqlpass.org/events/seattle/index.cfm
"Kimberly L. Tripp" <Kimberly@nospam.sqlskills.com> wrote in message
news:O7qNHBpbCHA.1728@tkmsftngp11...
> Well - this is a good question! When you first asked this I was quite
> perplexed...what the heck is a role owner (I though??).
>
> After a bit of a review thought, I found that you're right...you can
specify
> a role owner but I have NO IDEA what the heck it's used for... Role's are
> NOT the owners of objects (it's always the username of the creator that's
> the owner). So, I looked in the sysuers system table and I can't even find
> where the owner is maintained.  SO...I've decided I need to ask you the
next
> question... Where are you seeing it (such that you want to change it).
That
> will help me try and figure out how we can set that value.
>
> At this point though I think it's pretty benign...
>
> Let me know!
> kt
>
> Kimberly L. Tripp
> ********************
> Please do not send mail to me directly - reply on the newsgroup.
> Please include legible and tested code samples (and ddl if possible!).
This
> makes it easier to test and answer your questions. Thanks!
>
> "Jakub Jablonski" <jcja@ericpol.pl> wrote in message
> news:3D9D53F8.60802@ericpol.pl...
> > Hello,
> > when adding new role using sp_addrole I can specify the owner for that
> > role. How can I change the owner of the existing role?
> >
> > Regards,
> > Jakub Jablonski
> >
> > --
> > _____________________________________________
> > Jakub Jablonski
> > Junior System Engineer
> > Ericpol Telecom sp. z o.o.
> > Targowa 9A, 90-042 Lodz, Poland
> > e-mail: jcja@ericpol.pl
> > mobile:
> > tel: +48 42 6315520
> > fax: +48 42 6315555
> > http://www.ericpol.pl/
> > _____________________________________________
> >
>
>

Relevant Pages

  • Re: changing role owner
    ... > Andrew J. Kelly SQL MVP ... >> a role owner but I have NO IDEA what the heck it's used for... ... >>> Jakub Jablonski ... >>> Junior System Engineer ...
    (microsoft.public.sqlserver.security)
  • Re: changing role owner
    ... a role owner but I have NO IDEA what the heck it's used for... ... > Jakub Jablonski ... > Junior System Engineer ...
    (microsoft.public.sqlserver.security)